Обсуждение: Double quoted column name from DatabaseMetaData.getIndexInfo

Поиск
Список
Период
Сортировка

Double quoted column name from DatabaseMetaData.getIndexInfo

От
"ml-tb"
Дата:
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