Fix for SQLStatistics

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>, PostgreSQL odbc list <pgsql-odbc(at)postgresql(dot)org>
Subject: Fix for SQLStatistics
Date: 2001-05-15 19:18:10
Message-ID: 200105151918.f4FJIAJ21034@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc pgsql-patches

Attached is a small patch to SQLStatistics() to allow proper information
about CLUSTER and HASH indexes, as proposed by the ODBC code. Right now
the CLUSTER information is not maintained, but the HASH is accurate.
Also, I found that the tests for UNIQUE and CLUSTER were done using
atoi(). I don't think that works because these queries return 't' or
'f', not 1 or 0.

Can someone confirm I have have the t/f and 1/0 stuff correct, and can
someone test a HASH index to see that it displays properly? I don't
know how to call SQLStatistics.

Thanks.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

Attachment Content-Type Size
unknown_filename text/plain 5.0 KB

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2001-05-16 00:39:53 Re: Fix for SQLStatistics
Previous Message Ramiro Alba 2001-05-15 13:16:23 StarOffice5.2+psqlODBC+PostgreSQL-7.1.1

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2001-05-15 21:50:44 Re: Re: GIST question
Previous Message Jason Tishler 2001-05-15 18:02:59 Cygwin plpython patch