Re: backend crash on DELETE, reproducible locally

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: backend crash on DELETE, reproducible locally
Дата
Msg-id 2877.1541538838@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: backend crash on DELETE, reproducible locally  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: backend crash on DELETE, reproducible locally  (Ondřej Bouda <obouda@email.cz>)
Re: backend crash on DELETE, reproducible locally  (Ondřej Bouda <obouda@email.cz>)
Список pgsql-hackers
I wrote:
> Interestingly, it doesn't crash if I change the index type to btree,
> which I was not expecting because the crashing code seems pretty
> independent of the index type.

Oh ... duh.  The problem here is that ProjIndexIsUnchanged thinks that
the type of the index column is identical to the type of the source
datum for it, which is not true for any opclass making use of the
opckeytype property.

Ondřej, as a short-term workaround you could prevent the crash
by setting that index's recheck_on_update property to false.

            regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: pread() and pwrite()
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [HACKERS] generated columns