Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.8.8/8.7.5) with ESMTP id KAA27289 for ; Mon, 27 Apr 1998 10:14:36 -0400 (EDT) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.8.5/8.8.5) with UUCP id JAA25417 for pgsql-interfaces@postgreSQL.org; Mon, 27 Apr 1998 09:59:55 -0400 (EDT) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!byronn using -f Received: by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA29938; Mon, 27 Apr 1998 09:41:26 -0400 Received: from [3.0.0.50] by ceodev (AIX 4.1/UCB 5.64/4.03) id AA55914; Mon, 27 Apr 1998 09:37:40 -0400 Message-Id: <35448AFF.5A234B52@insightdist.com> Date: Mon, 27 Apr 1998 09:41:19 -0400 From: Byron Nikolaidis X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: Sbragion Denis Cc: pgsql-interfaces@postgreSQL.org, Stephen Davies Subject: Re: [INTERFACES] Odbc and Visual Basic References: <3.0.5.32.19980427102627.008acaa0@MBox.InfoTecna.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, This message is concerning the unique index problem. There is an ODBC function called SQLStatistics which currently does not properly handle reporting unique indexes. It never has in the past either. It assumed that Postgres could not have unique indexes. I have modified this function to return correct information concerning unique indexes from the Postgres system tables. I am currently testing it. A new driver will be up on the web site soon. Regards, Byron