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

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: \watch stuck on execution of commands returning no tuples
Date: 2013-05-02 23:53:39
Message-ID: 20130502235339.GB5933@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, May 2, 2013 at 10:01:28AM -0400, Tom Lane wrote:
> Michael Paquier <michael(dot)paquier(at)gmail(dot)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

OK, what other database supports British spelling of commands? Can we
call this a compatibility feature. ;-) The feature has been there
since 2000:

commit ebe0b236909732c75d665c73363bd4ac7a7aa138
Author: Bruce Momjian <bruce(at)momjian(dot)us>
Date: Wed Nov 8 21:28:06 2000 +0000

Add ANALYSE spelling of ANALYZE for vacuum.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2013-05-02 23:55:13 Re: Recovery target 'immediate'
Previous Message Bruce Momjian 2013-05-02 23:41:35 Re: Should pg_upgrade use --quote-all-identifiers?