Skip site navigation (1) Skip section navigation (2)

Notices during execution

From: Jason McKellar <jason(at)deadtreepages(dot)com>
To: psycopg(at)postgresql(dot)org
Subject: Notices during execution
Date: 2011-09-16 19:05:57
Message-ID: CAGZuaCyV4_e+-ZBuBFkjQO2StnNxdAveLNywhpGVZ+3EU7HfJQ@mail.gmail.com (view raw or flat)
Thread:
Lists: psycopg
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.

Thanks,

Jason

Responses

psycopg by date

Next:From: OswaldoDate: 2011-09-17 11:25:11
Subject: Re: Notices during execution
Previous:From: Marco BeriDate: 2011-09-07 10:05:09
Subject: Re: About pyvertica (a clone of pyscopg2)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group