COMMIT notification

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.

regards, tom lane

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

Viacheslav N Tararin <taras@dekasoft.com.ua> writes:

NOTIFY work, message will send on statement execution, but transaction
may be rolledback later.

No, the message is sent at commit. See the man page for NOTIFY.

regards, tom lane