Mike Haberman <mikeh@xxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
