Re: Notices during execution

El 16/09/2011 21:05, Jason McKellar escribió:
> Hello,
>
> Is there a way to get messages output using raise notice while a
> function is executing?
>
> I have a long-running (10 minutes) function that raises notices every 10
> seconds or so about what it is currently doing and would like to view
> them while the function is running. I suppose a workaround if I can't do
> this in Psycopg2 is to execute psql and get the stdout.
>

The connection object has a 'notices' property, see:
<http://initd.org/psycopg/docs/connection.html>

Note that if you use synchronous mode you can't check the messages ultil
the query has finished. I don't know if using threads the notices can be
readed while que query is in execution.

Regards

--
Oswaldo