Re: exclude table from transactions - Mailing list pgsql-general

From Tom Lane
Subject Re: exclude table from transactions
Date
Msg-id 26628.1259103456@sss.pgh.pa.us
Whole thread Raw
In response to exclude table from transactions  (Kurt <wazkelzu@gmx.net>)
List pgsql-general
Kurt <wazkelzu@gmx.net> writes:
> I'd like to ask, whether there is a way to exclude a table from the
> regular transaction rollback.

No.

> I want to log all exceptions caused by my plpgsql-functions in a certain
> log-table.

You could use dblink to connect to another session that has its own
transaction boundaries, and send commands to that session to insert
messages into your log table.

            regards, tom lane

pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: exclude table from transactions
Next
From: silly8888
Date:
Subject: Re: Partitioning table and dynamic SQL in trigger