Postgres Pro
Downloads
Home   >   mailing lists

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

From Robins
Subject Clarify 'dependent objects' for DROP COLUMN
Date
Msg-id CAEP4nAxFw=2pB-oJyWZkwo7hccggoDzooEBmv+umd1R-neyZXg@mail.gmail.com
Whole thread Raw
Responses Re: Clarify 'dependent objects' for DROP COLUMN
List pgsql-docs
Tree view
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

pgsql-docs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: The relation between "checkpoint_timeout" and "checkpoint_warning" is missing
Next
From: robins
Date:
Subject: Clarify 'dependent objects' for DROP COLUMN