Postgres Pro
Downloads
Home   >   mailing lists

Re: psql: show only failed queries - Mailing list pgsql-hackers

From Samrat Revagade
Subject Re: psql: show only failed queries
Date
Msg-id CAF8Q-GyJzay6z3L39nKZmsiEXC+RbcboqtPj_3XkTzi3rHqMKA@mail.gmail.com
Whole thread Raw
In response to Re: psql: show only failed queries  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: psql: show only failed queries  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Tree view
Hi Pavel,

After applying patch, on error condition it displays error message two times as follows:
 
ERROR:  column "abc" does not exist at character 23
STATEMENT:  insert into ax
values(abc);
psql:a.sql:7: ERROR:  column "abc" does not exist
LINE 2: values(abc);


user may confuse because of repeated error messages. so I think its better to display only one message, one of the possible ways is as follows:

ERROR:  column "abc" does not exist at character 23
STATEMENT:  insert into ax
values(abc);


Am I missing something ?



On Wed, Jun 4, 2014 at 9:52 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:



2014-06-04 18:16 GMT+02:00 Peter Eisentraut <peter_e@gmx.net>:

On 6/4/14, 11:54 AM, Pavel Stehule wrote:
> updated patch - only one change: query is prefixed by "QUERY:  "

In the backend server log, this is called "STATEMENT:  ".

good idea

updated patch 

Pavel


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers




--
Regards,

Samrat Revgade

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: pg_receivexlog add synchronous mode
Next
From: Marti Raudsepp
Date:
Subject: Re: Quantify small changes to predicate evaluation