Postgres Pro
Downloads
Home   >   mailing lists

Double quoted column name from DatabaseMetaData.getIndexInfo - Mailing list pgsql-jdbc

From ml-tb
Subject Double quoted column name from DatabaseMetaData.getIndexInfo
Date
Msg-id 201101271141.24062.ml-tb@emagixx.de
Whole thread Raw
List pgsql-jdbc
Tree view 
Driver version: 9.0.801
Server-Version: 8.4 (Linux X86_64), 9.02 (Win32)

This bug seems to be fixed in 2007 but occurs again.

The problem is the usage of:

  pg_catalog.pg_get_indexdef(ci.oid, (i.keys).n, false) AS COLUMN_NAME

that delivers the column name for the _definition_ of the index. The
definition needs the double qoutes for mixed case column names.

Bye Thomas

pgsql-jdbc by date:

Previous
From: Lukas Eder
Date:
Subject: Re: [HACKERS] Fwd: Weird issues when reading UDT from stored function
Next
From: Hugo Garza
Date:
Subject: My query table aliases don't exist in my application