Postgres Pro
Downloads
Home   >   mailing lists

Re: commit callback, request - Mailing list pgsql-hackers

From Tom Lane
Subject Re: commit callback, request
Date
Msg-id 29147.1144246455@sss.pgh.pa.us
Whole thread Raw
In response to commit callback, request  ("Pavel Stehule" <pavel.stehule@hotmail.com>)
Responses Re: commit callback, request  ("Pavel Stehule" <pavel.stehule@hotmail.com>)
Re: commit callback, request, SOLVED  ("Pavel Stehule" <pavel.stehule@hotmail.com>)
List pgsql-hackers
Tree view 
"Pavel Stehule" <pavel.stehule@hotmail.com> writes:
> Is possible make transaction commit trigger without patching code now?

You can get pretty close with a deferred trigger.  I don't think
there's any way to have a guaranteed "at commit" trigger --- as soon
as (1) there are two of them and (2) one can get an error, the
transaction could fail after running an alleged "at commit" trigger.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "stephen joseph butler"
Date:
Subject: Re: Stats collection on Windows
Next
From: Tom Lane
Date:
Subject: Re: Stats collection on Windows