Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: FOREIGN KEY migration of syntax, help needed
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Mike Haberman <mikeh(at)ncsa(dot)uiuc(dot)edu>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: FOREIGN KEY migration of syntax, help needed
- Date: Tue, 31 Jul 2007 16:00:59 -0400
Mike Haberman <mikeh(at)ncsa(dot)uiuc(dot)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
- Follow-Ups:
- Re: FOREIGN KEY migration of syntax, help needed
- From: Mike Haberman
- Re: FOREIGN KEY migration of syntax, help needed
- References:
- FOREIGN KEY migration of syntax, help needed
- From: Mike Haberman
- FOREIGN KEY migration of syntax, help needed
- Prev by Date: Re: Need quick help with standalone mode
- Next by Date: continue in plpgsql 7.4
- Previous by thread: FOREIGN KEY migration of syntax, help needed
- Next by thread: Re: FOREIGN KEY migration of syntax, help needed
- Indexes: