On Thu, May 2, 2013 at 11:01 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Michael Paquier <michael.paqu...@gmail.com> writes: > > Hi all, > > When testing \watch, I noticed that process waits indefinitely when > > executing it with a DDL or a DML. > > For example: > > postgres=# CREATE TABLE aa (a int); > > postgres=# ANALYSE aa \watch 10 > > -- Process waiting here > > It's not "waiting", it's doing the ANALYZE once every ten seconds, > just like you told it to. > > Perhaps it'd be a good idea to emit the command tag on receiving a > non-tuple-bearing result, just to make this more obvious. > Yes, the command tag would be a good idea, combined with the watch time that other commands returning tuples have, giving something like that: Watch every 2s Fri May 3 10:01:04 2013 $TAG Regards, -- Michael