Re: [HACKERS] Fix for initdb/indexing problems - Mailing list pgsql-hackers

From Keith Parks
Subject Re: [HACKERS] Fix for initdb/indexing problems
Date
Msg-id 199809030046.BAA12712@mtcc.demon.co.uk
Whole thread Raw
List pgsql-hackers
Bruce,

I'm just taking an update from CVS.

I'll kick off the process to build and test before I go to bed
and then check the results in the morning.

It's 1:45am and I've just logged off from work, connected to my
ISP and seen this mail.

I look forward to seeing a clean set of regression results in
a few hours.

Well done Bruce.

Thanks,
Keith.

Bruce Momjian <maillist@candle.pha.pa.us>
>
> OK, I have found the problem.  I looked AGAIN at CatalogIndexInsert(),
> because all problems seem to be localized there.  I remembered something
> Tom Szybist said yesterday while we were on the phone about Datum only
> being one value.
>
> I said they are chained together, which I saw in IndexFormDatum, but
> when I looked, I saw that the Datum pointer indexed in IndexFormDatum
> was only a single Datum value, not an array of datum values like nulls
> is defined.
>
> With single-key system indexes, this was not a problem, but with the new
> multi-key system indicies, it is.
>
> I have attached the patch, and it is applied to the tree.  Please let me
> know if this fixes the many reported index problems.  It should.
>


pgsql-hackers by date:

Previous
From: t-ishii@sra.co.jp (Tatsuo Ishii)
Date:
Subject: Re: [HACKERS] USE_LOCALE and unsigned char *
Next
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] Adding PRIMARY KEY info