[ Charset US-ASCII unsupported, converting... ]
> Bruce Momjian wrote:
> >
> > > Bruce Momjian <pgman@candle.pha.pa.us> writes:
>
> [snip]
>
> >
> > FYI, the reference to pg_index.indisclustered in ODBC was assuming it
> > meant it was a hash index,
>
> Hmm where could I see it ?
>
> > which is just plain wrong, so that code is
> > not coming back.
> >
I now think the original ODBC code was right. It has defined as
possible values:#define SQL_TABLE_STAT 0#define SQL_INDEX_CLUSTERED 1#define
SQL_INDEX_HASHED 2#define SQL_INDEX_OTHER 3
Not sure what SQL_TABLE_STAT is for, perhaps we should flag for
pg_statistics? Anyway, the test of the flag looks correct to me. Why
they would care only about HASH and CLUSTERED, I don't know.
I will restore the code, and fix the HASH while I am at it.
Of course, the cluster field is still alway false, but it will be ready
if we ever get it working.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026
