Re: Updating multiple bool values crashes backend

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Updating multiple bool values crashes backend
Дата
Msg-id 5781.972574042@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Updating multiple bool values crashes backend  (pgsql-bugs@postgresql.org)
Ответы Re: Updating multiple bool values crashes backend  (Sean Kelly <S.Kelly@ncl.ac.uk>)
Re: Updating multiple bool values crashes backend  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-bugs
Sean Kelly <S.Kelly@ncl.ac.uk> writes:
> (gdb) bt
> #0  0x8115eb2 in ri_BuildQueryKeyFull ()
> #1  0x8115dc2 in RI_FKey_keyequal_upd ()
> #2  0x8096d7c in DeferredTriggerSaveEvent ()

Hmm.  There wasn't any mention of foreign keys for this table in your
bug report, now was there?

At a guess, you've run into the known bug that foreign key triggers
don't track renames of referenced tables.  Did you rename a table that
is a foreign-key referencer or referencee of this one?  If so, rename
it back, or drop and reload both tables.  (The crash is fixed for
7.0.3, though actually tracking the renames is further downstream.)

            regards, tom lane

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

Предыдущее
От: "D. Jay Newman"
Дата:
Сообщение: Re: Select where (upper(xy)~'.CH'); ..matches also SPACE CH
Следующее
От: Sean Kelly
Дата:
Сообщение: Re: Updating multiple bool values crashes backend