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

Laurian Vostinar <lvostinar(at)servoy(dot)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(at)servoy(dot)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/