Home > mailing lists

Thread: Clarify 'dependent objects' for DROP COLUMN

Clarify 'dependent objects' for DROP COLUMN

From

robins

Date:

12 March 2013, 08:43:08

Hi,

ALTER TABLE in postgresql.org/docs/devel/ says:

RESTRICT: Refuse to drop the column or constraint if there are any dependent objects. This is the default behavior.

Could someone confirm whether 'dependent objects' also includes SEQUENCES? i.e. if I create a sequence OWNED BY tbl.col1 and then try to drop the column with RESTRICT, should it allow this DROP? Currently it does, but by reading that line it seemed it shouldn't.

Thanks

Robins Tharakan

p.s.: Had to re-post this. Apologies if this lands up twice in the queue.