Re: Timing of notice delivery - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Timing of notice delivery
Date
Msg-id 4D48A271.6040308@opencloud.com
Whole thread Raw
In response to Timing of notice delivery  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-jdbc
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

pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: Timing of notice delivery
Next
From: "Kevin Grittner"
Date:
Subject: Re: Timing of notice delivery