"CN" <cnliou9@xxxxxxxxxxx> 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
