Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-odbcpgsql-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

Responses

pgsql-odbc by date

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

pgsql-patches by date

Next:From: Bruce MomjianDate: 2001-05-15 21:50:44
Subject: Re: Re: GIST question
Previous:From: Jason TishlerDate: 2001-05-15 18:02:59
Subject: Cygwin plpython patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group