Re: BUG #17872: Dropping an attribute of a composite type breaks indexes over the type silently

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #17872: Dropping an attribute of a composite type breaks indexes over the type silently
Дата
Msg-id 3653799.1680031110@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #17872: Dropping an attribute of a composite type breaks indexes over the type silently  (Alexander Lakhin <exclusion@gmail.com>)
Список pgsql-bugs
Alexander Lakhin <exclusion@gmail.com> writes:
> So I agree, that disabling the drop operation when a composite type has
> dependencies is not a harmless change. On the other hand, the code might be
> not ready to deal with the uniqueness assumption violated.

Well, corrupt indexes are a fact of life and probably always will be,
because collations are such an unpredictable mess.  So if we have anyplace
that is straight out Assert'ing that uniqueness holds, I'd say that that
needs reconsideration.  We need to try to turn it into a helpful error
message.

> #5  0x000055d3131e314f in ExceptionalCondition (
>      conditionName=conditionName@entry=0x55d313357b85 "next_index == nparts",
>      fileName=fileName@entry=0x55d313357887 "partbounds.c", lineNumber=lineNumber@entry=884) at assert.c:66

Hmm.  I did not trace this down, but it doesn't look like it's exactly
connected to corrupt indexes.

            regards, tom lane



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