Re: psql: show only failed queries

Поиск
Список
Период
Сортировка
От Samrat Revagade
Тема Re: psql: show only failed queries
Дата
Msg-id CAF8Q-GyJzay6z3L39nKZmsiEXC+RbcboqtPj_3XkTzi3rHqMKA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: psql: show only failed queries  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: psql: show only failed queries
Список 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.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 по дате отправления: