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/