"CN" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq