Re: pre-commit triggers - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: pre-commit triggers
Date
Msg-id 5288F22E.2080506@2ndQuadrant.com
Whole thread Raw
In response to Re: pre-commit triggers  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
On 11/17/2013 04:20 PM, Alvaro Herrera wrote:
> Hannu Krosing wrote:
>
>> So it would send a network message, a signal or writing something to
>> external file.
> If you're OK with a C function, you could try registering a callback,
> see RegisterXactCallback().
>
I already have an implementation doing just that, thoughg having a
trigger would be perhaps clearer :)

And I suspect that calling a pl/* function after the ROLLBACK has
actually happened due to
error is a no-go anyway, so it has to be C.

Cheers

-- 
Hannu Krosing
PostgreSQL Consultant
Performance, Scalability and High Availability
2ndQuadrant Nordic OÜ




pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pre-commit triggers
Next
From: Tom Lane
Date:
Subject: Re: Using indices for UNION.