"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