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

2013-05-17 Thread Bruce Momjian
On Tue, May 7, 2013 at 02:47:16PM -0400, Robert Haas wrote: > On Tue, May 7, 2013 at 2:36 PM, Ian Lawrence Barwick > wrote: > > As a British native speaker involved in translating some PostgreSQL-related > > Japanese text, all I can say is "yes please". (Although for true Japanese > > support, t

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

2013-05-07 Thread Robert Haas
On Tue, May 7, 2013 at 2:36 PM, Ian Lawrence Barwick wrote: > As a British native speaker involved in translating some PostgreSQL-related > Japanese text, all I can say is "yes please". (Although for true Japanese > support, the grammar would have to be pretty much reversed, with the verb > being

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

2013-05-07 Thread Ian Lawrence Barwick
2013/5/8 Robert Haas : > On Thu, May 2, 2013 at 7:53 PM, Bruce Momjian wrote: >> OK, what other database supports British spelling of commands? Can we >> call this a compatibility feature. ;-) The feature has been there >> since 2000: >> >> commit ebe0b236909732c75d665c73363bd4ac7a7aa13

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

2013-05-07 Thread Robert Haas
On Thu, May 2, 2013 at 7:53 PM, Bruce Momjian wrote: > 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 Momj

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

2013-05-05 Thread Michael Paquier
On Sun, May 5, 2013 at 5:42 AM, Tom Lane wrote: > Michael Paquier writes: > > On Thu, May 2, 2013 at 11:01 PM, Tom Lane wrote: > >> 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

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

2013-05-04 Thread Tom Lane
Michael Paquier writes: > On Thu, May 2, 2013 at 11:01 PM, Tom Lane wrote: >> 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 com

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

2013-05-02 Thread Michael Paquier
On Thu, May 2, 2013 at 11:01 PM, Tom Lane wrote: > Michael Paquier 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 > > --

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

2013-05-02 Thread Bruce Momjian
On Thu, May 2, 2013 at 10:01:28AM -0400, Tom Lane wrote: > Michael Paquier writes: > > Hi all, > > When testing \watch, I noticed that process waits indefinitely when > > executing it with a DDL or a DML. > > For example: > > postgres=# CREA

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

2013-05-02 Thread Tom Lane
Michael Paquier 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 o

[HACKERS] \watch stuck on execution of commands returning no tuples

2013-05-01 Thread Michael Paquier
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 By referring at do_watch:command.c, the feature is made such as there is no error