From: | Jorge Solórzano <jorsol(at)gmail(dot)com> |
---|---|
To: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
Cc: | List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Using \errverbose through JDBC |
Date: | 2017-02-01 15:11:16 |
Message-ID: | CA+cVU8N3wJ0gXtqSkx3LhuTiMPs40YeDpH4iuiRunYZRx8Bo9w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-02-01 15:24:01 | Re: Using \errverbose through JDBC |
Previous Message | Dave Cramer | 2017-02-01 13:41:33 | Re: Using \errverbose through JDBC |