Thread: foreign key constraints and alter table

If I'm reading the docs correctly, I should be able to write:

ALTER TABLE mytable ADD ptr INT4 REFERENCES othertable ON DELETE SET NULL

but when I look in pg_constraint table (pg 7.3) I don't see any kind
of foreign key constraint.

BTW, are the PDF versions of the 7.3 Docs? I only see 7.2 on the web site.

Thanks!

John DeSoi, Ph.D.

John DeSoi <jdesoi@planetc.com> writes:
> If I'm reading the docs correctly, I should be able to write:
> ALTER TABLE mytable ADD ptr INT4 REFERENCES othertable ON DELETE SET NULL
> but when I look in pg_constraint table (pg 7.3) I don't see any kind
> of foreign key constraint.

ALTER TABLE ADD COLUMN is dropping foreign key clauses in 7.3-7.3.2 :-(
See patch posted about four days ago.  In the meantime, add the foreign
key separately.

            regards, tom lane