-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Tom Lane a écrit : > 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
Thanks for having helped me understand better why it couldn't be a logical way of acting. Best regards, - -- Stéphane Schildknecht PostgreSQLFr - http://www.postgresql.fr Dalibo - http://www.dalibo.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJNRmvA+REPKWGI0ERAkeIAKCMucAjbCS8tw5kXJqyCuNWS7pMjQCgu2MU U4rECUpyOm5rqnr0FRmBT6o= =b7ow -----END PGP SIGNATURE----- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
