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

Can someone fix this issue, please ?

Regards, Laurian

-------- Original Message --------

Subject:	Re: [BUGS] BUG #6253: JDBC driver: getIndexInfo() returns quotes around quoted column names
Date:	Wed, 19 Oct 2011 08:01:02 -0400
From:	Robert Haas <robertmhaas@gmail.com>
To:	Laurian Vostinar <lvostinar@servoy.com>
CC:	pgsql-bugs@postgresql.org

On Wed, Oct 12, 2011 at 10:03 AM, Laurian Vostinar <lvostinar@servoy.com> wrote:
>
> 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

I think you'll need to try the pgsql-jdbc list, as this list is only
for bugs in the core distribution.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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/