Re: getting async raise notice messages
| От | Dave Cramer |
|---|---|
| Тема | Re: getting async raise notice messages |
| Дата | |
| Msg-id | CADK3HHJ9PzwbfeQwVDY8dbbE2FiYCQQhgEWuajrisT8EMm3gyw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: getting async raise notice messages (Pawel Veselov <pawel.veselov@gmail.com>) |
| Ответы |
Re: getting async raise notice messages
Re: getting async raise notice messages |
| Список | pgsql-jdbc |
Pawel,
Have a look at org/postgresql/test/jdbc2/NotifyTest.java for exactly what you proposed. As for when it gets notified, I do not know how you would tell as the spec does not provide this functionality (AFAIK)
On 26 January 2015 at 17:52, Pawel Veselov <pawel.veselov@gmail.com> wrote:
Dave,On Mon, Jan 26, 2015 at 2:38 PM, Dave Cramer <pg@fastcrypt.com> wrote:Dave CramerI've seen that :) May be I'm missing something, but that's not asynchronous. I need to wait until statement finishes before calling those getWarnings() methods. May be I can call them from another thread (at least on Connection/Statement object) as the SQL is being processed, and they will return current messages, but I'm not sure when to - i.e. how do I know when a new message has been made available.On 26 January 2015 at 17:06, Pawel Veselov <pawel.veselov@gmail.com> wrote:Hi.Is it possible to get output of raise notice statements as produced by a PL function, as the function is being executed? And if yes, what version was that introduced in?
В списке pgsql-jdbc по дате отправления: