On Tue, Apr 19, 2011 at 4:39 PM, giova <giovainsta...@yahoo.fr> wrote: > My problem is that i want to do an INSERT into a log table before to raise > the exception. But RAISE EXCEPTION cancels my Insert.
That's the point of transaction, if it failed the data and any other changes are rolled back. You can use dblink (http://www.postgresql.org/docs/current/static/dblink.html), which will issue a separate connection to database to simulate autonomous transaction. Regards, Taras Kopets -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
