Double quoted column name from DatabaseMetaData.getIndexInfo

Lists: pgsql-jdbc
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
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