Adrian Klaver <[EMAIL PROTECTED]> writes: > Thanks for the explanation. Just so I am clear,the act of updating the row in > p_commandeligne_ad creates a new tuple for the row with id of 1. This means > the original statement "delete from commande where id=1" runs against a > version of the row that no longer exists and becomes a no-op statement. This > happens because the trigger was run as BEFORE and changed the row from under > the original statement.
Right. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general