Postgres Pro
Downloads
Home   >   mailing lists

Re: JDBC driver and Postgres 9.6beta - Mailing list pgsql-jdbc

From Vladimir Sitnikov
Subject Re: JDBC driver and Postgres 9.6beta
Date
Msg-id CAB=Je-FUuFi0jUi4BCiTi5WuguJLgek=k2nt6LkZ8GfghVQbwQ@mail.gmail.com
Whole thread Raw
In response to JDBC driver and Postgres 9.6beta  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: JDBC driver and Postgres 9.6beta  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: JDBC driver and Postgres 9.6beta  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-jdbc
Tree view
Thanks for the report,

I've commented out amcanorder for 9.6 here: https://github.com/pgjdbc/pgjdbc/pull/560

Does anybody know what is the proper way to tell if index column is ASC or DESC in 9.6+?

pgjdbc used something like
  CASE pg_am.amcanorder
    WHEN true THEN CASE pg_index.indoption[(pg_index.keys).n - 1] & 1 
      WHEN 1 THEN 'D' 
      ELSE 'A' 
    END 
    ELSE NULL 
  END AS ASC_OR_DESC, 

Vladimir

pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: JDBC driver and Postgres 9.6beta
Next
From: Tom Lane
Date:
Subject: Re: JDBC driver and Postgres 9.6beta