| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Timing of notice delivery |
| Date: | 2011-02-02 00:16:49 |
| Message-ID: | 4D48A271.6040308@opencloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-02-02 00:31:50 | Re: Timing of notice delivery |
| Previous Message | Kevin Grittner | 2011-02-01 23:51:33 | Timing of notice delivery |