Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Foreign key constraint delete fire order
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "CN" <cnliou9(at)fastmail(dot)fm>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Foreign key constraint delete fire order
- Date: Fri, 29 Sep 2006 11:24:38 -0400
"CN" <cnliou9(at)fastmail(dot)fm> writes: > I wish foreign key constraint trigger guarantees that rows in > referensing table are deleted before the rows in referenced table is > deleted. > ... > Does my wish make sense or violate any standard? Sorry, the SQL standard says that it happens in the current order (rows deleted as a consequence of RI actions are to be dropped at the *end* of the SQL-statement). regards, tom lane
- References:
- Prev by Date: Re: 8.1.4 compile problem
- Next by Date: Re: benchmark suite
- Previous by thread: Foreign key constraint delete fire order
- Next by thread: benchmark suite
- Indexes: