Re: [JDBC] Using \errverbose through JDBC - Mailing list pgsql-jdbc

From Jorge Solórzano
Subject Re: [JDBC] Using \errverbose through JDBC
Date
Msg-id CA+cVU8N3wJ0gXtqSkx3LhuTiMPs40YeDpH4iuiRunYZRx8Bo9w@mail.gmail.com
Whole thread Raw
In response to [JDBC] Using \errverbose through JDBC  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: [JDBC] Using \errverbose through JDBC
Re: [JDBC] Using \errverbose through JDBC
Re: Using \errverbose through JDBC
Re: Using \errverbose through JDBC
List 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 by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Using \errverbose through JDBC
Next
From: Tom Lane
Date:
Subject: Re: [JDBC] Using \errverbose through JDBC