Re: getIndexInfo() not returning operator classes

From: Kris Jurka <books(at)ejurka(dot)com>
To: Thomas Kellerer <spam_eater(at)gmx(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: getIndexInfo() not returning operator classes
Date: 2005-11-10 07:00:36
Message-ID: Pine.BSO.4.61.0511100152300.25311@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thu, 10 Nov 2005, Thomas Kellerer wrote:

> 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.

I'm not sure where you'd like to see the opclass displayed in the results
of getIndexInfo. Also consider that every indexed column has a opclass,
the default or a user specified one.

Kris Jurka

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Rob Kirkbride 2005-11-10 11:54:37 More Verbose Logging of Statements
Previous Message Srivats 2005-11-10 05:20:10 Getting param names