Postgres Pro
Downloads
Home   >   mailing lists

Query available indexes via jdbc meta data does not work any more in PostgreSQL 9.6.0 - Mailing list pgsql-bugs

From Tillmann Schulz
Subject Query available indexes via jdbc meta data does not work any more in PostgreSQL 9.6.0
Date
Msg-id 764633190.4268678.1476107174279@mail.yahoo.com
Whole thread Raw
Responses Re: Query available indexes via jdbc meta data does not work any more in PostgreSQL 9.6.0
Re: [BUGS] Query available indexes via jdbc meta data does not work any more in PostgreSQL 9.6.0
List pgsql-bugs
Tree view 
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
jdbcmeta 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

pgsql-bugs by date:

Previous
From: Simplex
Date:
Subject: memory leak in libpq , definitely lost: 200 bytes in 1 blocks, indirectly lost: 2,048 bytes in 1 blocks ...
Next
From: Heikki Linnakangas
Date:
Subject: Re: memory leak in libpq , definitely lost: 200 bytes in 1 blocks, indirectly lost: 2,048 bytes in 1 blocks ...