Re: Timing of notice delivery

On 02/02/11 12:51, Kevin Grittner wrote:

> -- setup
> Execute LISTEN on the connection.
> conn.setAutoCommit(false);
> -- each transaction
> execute statements which fire triggers which NOTIFY.
> conn.commit();
> conn.getNotifications();
>
> Can I count on all notifications triggered during a transaction
> being delivered in the last step?

This is equivalent to asking "Does the server deliver all notifications
before sending ReadyForQuery in response to Sync after the commit
command?". The last thing the driver processes from the server before
returning from commit() is the RFQ message.

Oliver