getIndexInfo() not returning operator classes - Mailing list pgsql-jdbc

From Thomas Kellerer
Subject getIndexInfo() not returning operator classes
Date
Msg-id dku3nu$8k2$1@sea.gmane.org
Whole thread Raw
Responses Re: getIndexInfo() not returning operator classes  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Hello,

when I call getIndexInfo() it correctly returns the definition for
function based indexes, but it does not return operator classed.

An index: create index idx_foo on foo(bar varchar_pattern_ops);

will show up as "bar" only in the definition column of the result set.
This makes it a bit confusing if you have another index like:

create index idx_foo_2 on foo(bar);

Which will show two identical index definitions even though they are
different.

I tested this with PG 8.1 and the 8.1 build 404 driver on Windows 2000


Regards
Thomas

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: use of OID.Unknown
Next
From: "Srivats"
Date:
Subject: Getting param names