Re: \watch stuck on execution of commands returning no tuples

On Thu, May  2, 2013 at 10:01:28AM -0400, Tom Lane wrote:> Michael Paquier <michael.paquier@gmail.com> writes:> >
Hiall,> > When testing \watch, I noticed that process waits indefinitely when> > executing it with a DDL or a DML.> >
Forexample:> > postgres=# CREATE TABLE aa (a int);
 
-->    > > postgres=# ANALYSE aa \watch 10                      -------
> > -- Process waiting here

OK, what other database supports British spelling of commands?  Can we
call this a compatibility feature.  ;-)  The feature has been there
since 2000:
commit ebe0b236909732c75d665c73363bd4ac7a7aa138Author: Bruce Momjian <bruce@momjian.us>Date:   Wed Nov 8 21:28:06 2000
+0000   Add ANALYSE spelling of ANALYZE for vacuum.
 


--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +