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
Re: [JDBC] Using \errverbose through JDBC Re: Using \errverbose through JDBC Re: Using \errverbose through JDBC |
| Список | 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,
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 по дате отправления: