[ psqlodbc-Bugs-1000745 ] SQLStatistics does not return indices based on expression

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1000745 ] SQLStatistics does not return indices based on expression
Date: 2006-10-05 09:41:42
Message-ID: 20061005094142.61A5186CA7A@pgfoundry.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Bugs item #1000745, was opened at 2006-10-05 13:41
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000745&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Dmitriy Ivanov (divanov)
Assigned to: Nobody (None)
Summary: SQLStatistics does not return indices based on expression

Initial Comment:
Driver 08.02.0103 ANSI. After executing

CREATE UNIQUE INDEX employee_name_idx
ON employee (upper(last_name || ' ' || first_name));

I can see employee_name_idx in pgAdminIII, DROP INDEX also works, but SQLStatistics does not mention it.

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000745&group_id=1000125

Browse pgsql-odbc by date

  From Date Subject
Next Message Obe, Regina 2006-10-06 08:59:42 Is there an ODBC driver available for Windows 2003 64-bit
Previous Message noreply 2006-10-05 02:30:27 [ psqlodbc-Bugs-1000744 ] 08.02.01: Incorrect size returned for adVarWChar and adVarChar fields after Paremeters.Refresh.