Re: COMMIT notification - Mailing list pgsql-general

From Viacheslav N Tararin
Subject Re: COMMIT notification
Date
Msg-id 3E4A0729.6080107@dekasoft.com.ua
Whole thread Raw
In response to COMMIT notification  (Viacheslav N Tararin <taras@dekasoft.com.ua>)
Responses Re: COMMIT notification  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane пишет:

>Viacheslav N Tararin <taras@dekasoft.com.ua> writes:
>
>
>>How I can get notification inside database about transaction commiting?
>>
>>
>
>Um ... what entity, exactly, are you desiring to notify?  The
>LISTEN/NOTIFY mechanism might work for this.  Or not.  I'm not sure
>what you need to do.
>
>
I need to send in my MOM information about fixed transaction.
NOTIFY work, message will send on statement execution, but transaction
may be rolledback later.

Can I tune NOTIFICATION engine to delay messages until transaction
commit and discard notification when rollback?

Thanks


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: COMMIT notification
Next
From: bruno peracchio
Date:
Subject: view w/pgaccess