Re: getting async raise notice messages

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)

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On 26 January 2015 at 17:52, Pawel Veselov <pawel(dot)veselov(at)gmail(dot)com> wrote:

> Dave,
>
> On Mon, Jan 26, 2015 at 2:38 PM, Dave Cramer <pg(at)fastcrypt(dot)com> wrote:
>
>> http://www.postgresql.org/message-id/46A5E225.2070903@lewczuk.com
>>
>> Dave Cramer
>>
>
> I'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.
>
>
>> dave.cramer(at)credativ(dot)ca
>> http://www.credativ.ca
>>
>> On 26 January 2015 at 17:06, Pawel Veselov <pawel(dot)veselov(at)gmail(dot)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?
>>>
>>>
>