Double quoted column name from DatabaseMetaData.getIndexInfo

From: "ml-tb" <ml-tb(at)emagixx(dot)de>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Double quoted column name from DatabaseMetaData.getIndexInfo
Date: 2011-01-27 10:41:23
Message-ID: 201101271141.24062.ml-tb@emagixx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Browse pgsql-jdbc by date

  From Date Subject
Next Message Hugo Garza 2011-02-01 22:23:06 My query table aliases don't exist in my application
Previous Message rsmogura 2011-01-25 09:06:10 Re: [HACKERS] Fwd: Weird issues when reading UDT from stored function