Re: [DOCS] Clarify 'dependent objects' for DROP COLUMN

2013-03-13 Thread Bruce Momjian
On Thu, Mar 14, 2013 at 03:38:42AM +0530, robins wrote: > Thanks Bruce. > > I think by using the word 'constraint' I understand what the documentation > meant. > > Both my queries (samples given below) arose from the fact that although there > was a 'relation', this is probably not what the docu

Re: [DOCS] Clarify 'dependent objects' for DROP COLUMN

2013-03-13 Thread robins
Thanks Bruce. I think by using the word 'constraint' I understand what the documentation meant. Both my queries (samples given below) arose from the fact that although there was a 'relation', this is probably not what the documentation was talking about. Q1: postgres=# CREATE TABLE serialTest3 (

Re: [DOCS] Clarify 'dependent objects' for DROP COLUMN

2013-03-13 Thread Bruce Momjian
On Tue, Mar 12, 2013 at 09:51:44AM +0530, Robins wrote: > 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 i