Re: alter table - Mailing list pgsql-bugs

"Diego Cattelan" <netmaniac@libero.it> writes:
> gesart=3D>alter table a add column c integer references xxxxxxx(id);
> =20
> NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
> ALTER TABLE
> =20
> The table xxxxxxx doesn't exist.
> =20
> Is that correct or postgreSQL should report an error ?

It is an error.  7.3.* has a bug with ALTER TABLE ADD COLUMN: any
foreign-key reference clauses are ignored.  This is fixed for 7.3.3.

            regards, tom lane