On Thu, May 2, 2013 at 11:01 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Michael Paquier <michael.paquier@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