Re: Timing of notice delivery

Поиск
Список
Период
Сортировка
От Oliver Jowett
Тема Re: Timing of notice delivery
Дата
Msg-id 4D48A271.6040308@opencloud.com
обсуждение исходный текст
Ответ на Timing of notice delivery  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Timing of notice delivery
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Timing of notice delivery