Re: [HACKERS] Fix for initdb/indexing problems

Поиск
Список
Период
Сортировка
От Keith Parks
Тема Re: [HACKERS] Fix for initdb/indexing problems
Дата
Msg-id 199809030925.KAA18833@mtcc.demon.co.uk
обсуждение исходный текст
Ответы Re: [HACKERS] Fix for initdb/indexing problems  ("Thomas A. Szybist" <szybist@boxhill.com>)
Список pgsql-hackers
Bruce,

Just to confirm, your fixes are just the job.

The regression tests run fine with only the failures I have always
seen due to maths precision and SIGFPE handling.

Thanks for your persistence in tracking this "bug" down.

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 по дате отправления:

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: [HACKERS] USE_LOCALE and unsigned char *
Следующее
От: mummert&partner_meskesm@WestLB.de
Дата:
Сообщение: Index problems