Re: exclude table from transactions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kurt <wazkelzu(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: exclude table from transactions
Date: 2009-11-24 22:57:36
Message-ID: 26628.1259103456@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kurt <wazkelzu(at)gmx(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message silly8888 2009-11-24 23:35:56 Re: Partitioning table and dynamic SQL in trigger
Previous Message Christophe Pettus 2009-11-24 22:55:31 Re: exclude table from transactions