Query available indexes via jdbc meta data does not work any more in PostgreSQL 9.6.0

From: Tillmann Schulz <tillmann73(at)yahoo(dot)de>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Query available indexes via jdbc meta data does not work any more in PostgreSQL 9.6.0
Date: 2016-10-10 13:46:14
Message-ID: 764633190.4268678.1476107174279@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-jdbc

Hello,

We are using Postgres 9.5 and want to migrate to 9.6.0.
Unfortuantelly our application works with 9.5 but doesn't work with 9.6. It fails while querying index informations via jdbc meta data.

The error message is:

Caused by: org.postgresql.util.PSQLException: ERROR: Column am.amcanorder doesnt exist
Position: 427
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:286)
at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getIndexInfo(AbstractJdbc2DatabaseMetaData.java:4234)

It would be nice, if Postgres 9.6 could query index information via jdbc meta data.

Best regards

Tillmann Schulz

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2016-10-10 14:14:59 Re: memory leak in libpq , definitely lost: 200 bytes in 1 blocks, indirectly lost: 2,048 bytes in 1 blocks ...
Previous Message Simplex 2016-10-10 09:38:08 memory leak in libpq , definitely lost: 200 bytes in 1 blocks, indirectly lost: 2,048 bytes in 1 blocks ...

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2016-10-10 14:47:11 Re: Query available indexes via jdbc meta data does not work any more in PostgreSQL 9.6.0
Previous Message Kaname Furutani 2016-10-07 01:33:51 Re: Can't download 9.4.1211 source file.