Re: Fwd: Re: [BUGS] BUG #6253: JDBC driver: getIndexInfo() returns quotes around quoted column names

Laurian Vostinar <lvostinar@servoy.com> writes:

> Can someone fix this issue, please ?

Given

  create table x( "I""D" int4 not null, primary key("I""D") );
  create unique index x_plus on x (("I""D" + 17 ));

I get

  I"D
  (("I""D" + 17))

on 8.2 while it's

  "I""D"
  (("I""D" + 17))

on 9.1; or >= 8.3.

In the case of expression indexes, what do you expect to recieve?  How
would one differentiate between the literal column name ((1)) and an
expression?

[snip]
>>
>> The following bug has been logged online:
>>
>> Bug reference:      6253
>> Logged by:          Laurian Vostinar
>> Email address:      lvostinar@servoy.com
>> PostgreSQL version: 9.0
>> Operating system:   Windows 7
>> Description:        JDBC driver: getIndexInfo() returns quotes around quoted
>> column names
>> Details:
>>
>> Old bug has returned, see
>> http://postgresql.1045698.n5.nabble.com/Old-bug-reappeared-JDBC-driver-getIn
>> dexInfo-returns-quotes-around-quoted-column-names-td4553591.html
>>
>> http://archives.postgresql.org/pgsql-jdbc/2011-01/msg00065.php
>>
>> http://archives.postgresql.org/pgsql-bugs/2007-07/msg00104.php

--
   Johann Oskarsson                http://www.2ndquadrant.com/    |[]
   PostgreSQL Development, 24x7 Support, Training and Services  --+--
                                                                  |
   Blog: http://my.opera.com/myrkraverk/blog/