Re: psql: show only failed queries
| От | Pavel Stehule |
|---|---|
| Тема | Re: psql: show only failed queries |
| Дата | |
| Msg-id | CAFj8pRBXQV5Gousp3jpn2k=MXuaZn-T5FzmoFuXqUfonVaXNMg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: psql: show only failed queries (Samrat Revagade <revagade.samrat@gmail.com>) |
| Ответы |
Re: psql: show only failed queries
Re: psql: show only failed queries |
| Список | pgsql-hackers |
2014-06-25 12:32 GMT+02:00 Samrat Revagade <revagade.samrat@gmail.com>:
LINE info is a part of error message and should be eliminated by terse mode
Hi Pavel,After applying patch, on error condition it displays error message two times as follows:ERROR: column "abc" does not exist at character 23STATEMENT: insert into axvalues(abc);psql:a.sql:7: ERROR: column "abc" does not existLINE 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 23STATEMENT: insert into axvalues(abc);Am I missing something ?
[pavel@localhost ~]$ psql -v ECHO=error -f test.sql postgres > /dev/null
psql:test.sql:4: ERROR: syntax error at or near ";"
LINE 2: 10 + ;
^
psql:test.sql:4: STATEMENT: select
10 + ;
psql:test.sql:8: ERROR: syntax error at end of input
LINE 2: 30 +
^
psql:test.sql:8: STATEMENT: select
30 +
psql:test.sql:4: ERROR: syntax error at or near ";"
LINE 2: 10 + ;
^
psql:test.sql:4: STATEMENT: select
10 + ;
psql:test.sql:8: ERROR: syntax error at end of input
LINE 2: 30 +
^
psql:test.sql:8: STATEMENT: select
30 +
but you can switch to terse mode:
[pavel@localhost ~]$ psql -v ECHO=error -v VERBOSITY=terse -f test.sql postgres > /dev/null
psql:test.sql:4: ERROR: syntax error at or near ";" at character 13
psql:test.sql:4: STATEMENT: select
10 + ;
psql:test.sql:8: ERROR: syntax error at end of input at character 13
psql:test.sql:8: STATEMENT: select
30 +
[pavel@localhost ~]$ psql -v ECHO=error -v VERBOSITY=terse -f test.sql postgres > /dev/null
psql:test.sql:4: ERROR: syntax error at or near ";" at character 13
psql:test.sql:4: STATEMENT: select
10 + ;
psql:test.sql:8: ERROR: syntax error at end of input at character 13
psql:test.sql:8: STATEMENT: select
30 +
What is what you would
I am sending updated patch - buggy statement is printed via more logical psql_error function instead printf
Regards
Pavel
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:In the backend server log, this is called "STATEMENT: ".
> updated patch - only one change: query is prefixed by "QUERY: "good ideaupdated patchPavel
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 по дате отправления: