getIndexInfo() is not returning filter condition.

From: Yair Ohayon <yair-o(at)orbotech(dot)com>
To: "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: getIndexInfo() is not returning filter condition.
Date: 2005-08-07 10:15:47
Message-ID: 1EDEACC2A4D2D9118271000802249A74AF7EE5@excg-isl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi ,

I'm trying to use getIndexInfo() to get index data , the one field which
seems to be wrongly null is filter_condition.
I'm working with postgresql 8.03 , Java 1.5_b04,jdbc
postgresql-8.0-312.jdbc3.jar (tried with 7.4 as well).

the sql statement which created the index is :

CREATE INDEX test
ON gdm
USING btree
(datetime, logid, threshold, opendmessage)
WHERE logid::text = 'ttt'::text AND threshold::text = 'YYYY'::text;

I get the same from pgadmin.

Is this bug known ? am i doing something wrong?

No reference in FAQ,archive and google groups...
Thanks.
Yair.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2005-08-07 22:04:34 Re: getIndexInfo() is not returning filter condition.
Previous Message Oliver Jowett 2005-08-05 00:34:06 Re: UNSUBSCRIBE