Re: Using \errverbose through 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(at)gmx(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>