Re: [JDBC] Using \errverbose through JDBC

Поиск
Список
Период
Сортировка
От Jorge Solórzano
Тема Re: [JDBC] Using \errverbose through JDBC
Дата
Msg-id CA+cVU8N3wJ0gXtqSkx3LhuTiMPs40YeDpH4iuiRunYZRx8Bo9w@mail.gmail.com
обсуждение исходный текст
Ответ на [JDBC] Using \errverbose through JDBC  (Thomas Kellerer <spam_eater@gmx.net>)
Ответы Re: [JDBC] Using \errverbose through JDBC  (Thomas Kellerer <spam_eater@gmx.net>)
Re: [JDBC] Using \errverbose through JDBC  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Using \errverbose through JDBC  (Thomas Kellerer <spam_eater@gmx.net>)
Re: Using \errverbose through JDBC  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-jdbc
The use case for this is?

AFAICT this is a libpq functionality, and since the JDBC driver is not libpq based then it can't use that functionality.

And it doesn't looks to be that useful for JDBC users:

postgres=# select * from pg_catalog.pg_type;
postgres=# \errverbose
There is no previous error.
postgres=# select * from pg_catalog.pg_types;
ERROR:  relation "pg_catalog.pg_types" does not exist
LÍNEA 1: select * from pg_catalog.pg_types;
                       ^
postgres=# \errverbose
ERROR:  42P01: relation "pg_catalog.pg_types" does not exist
LÍNEA 1: select * from pg_catalog.pg_types;
                       ^
UBICACIÓN:  parserOpenTable, parse_relation.c:1138
postgres=# select 1/0;
ERROR:  division by zero
postgres=# \errverbose
ERROR:  22012: division by zero
UBICACIÓN:  int4div, int.c:719

 
Regards,


Jorge Solórzano
me.jorsol.com

On Wed, Feb 1, 2017 at 7:18 AM, Thomas Kellerer <spam_eater@gmx.net> wrote:
Hello,

Postgres 9.6 introduced a new feature in libpq to get more detailed information about an error message.

This can currently only be used in psql using the \errverbose command or by changing the VERBOSITY variable.

I wonder if this is also available through JDBC somehow?

Regards
Thomas



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

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Using \errverbose through JDBC
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [JDBC] Using \errverbose through JDBC