Clarify 'dependent objects' for DROP COLUMN - Mailing list pgsql-docs

From robins
Subject Clarify 'dependent objects' for DROP COLUMN
Date
Msg-id CAEP4nAxJzygfcywQDg3R=K=ZioF51xXF4v2e6A9NrWP-Un=P=Q@mail.gmail.com
Whole thread Raw
List pgsql-docs
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.

pgsql-docs by date:

Previous
From: Robins
Date:
Subject: Clarify 'dependent objects' for DROP COLUMN
Next
From: Bruce Momjian
Date:
Subject: Re: Clarify 'dependent objects' for DROP COLUMN