Re: FOREIGN KEY migration of syntax, help needed - Mailing list pgsql-general

Mike Haberman <mikeh@ncsa.uiuc.edu> writes:
>    Will the following take care of all three statements?

>    ALTER TABLE ONLY assettype
>    ADD CONSTRAINT at_fk_1 FOREIGN KEY (pid) REFERENCES assettype(id)
>    ON UPDATE CASCADE ON DELETE CASCADE;

Yes, there are three or so triggers under the hood of any FOREIGN KEY
constraint.

            regards, tom lane