"Diego Cattelan" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
