Re: psql: show only failed queries

From: Samrat Revagade <revagade(dot)samrat(at)gmail(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, Fabrízio Mello <fabriziomello(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: psql: show only failed queries
Date: 2014-06-25 10:32:39
Message-ID: CAF8Q-GyJzay6z3L39nKZmsiEXC+RbcboqtPj_3XkTzi3rHqMKA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(dot)stehule(at)gmail(dot)com>
wrote:

>
>
>
> 2014-06-04 18:16 GMT+02:00 Peter Eisentraut <peter_e(at)gmx(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>
>

--
Regards,

Samrat Revgade

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marti Raudsepp 2014-06-25 10:42:15 Re: Quantify small changes to predicate evaluation
Previous Message Fujii Masao 2014-06-25 09:35:34 Re: pg_receivexlog add synchronous mode