Re: Updating multiple bool values crashes backend - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Updating multiple bool values crashes backend
Date
Msg-id 5781.972574042@sss.pgh.pa.us
Whole thread Raw
In response to Updating multiple bool values crashes backend  (pgsql-bugs@postgresql.org)
Responses Re: Updating multiple bool values crashes backend
Re: Updating multiple bool values crashes backend
List 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 by date:

Previous
From: "D. Jay Newman"
Date:
Subject: Re: Select where (upper(xy)~'.CH'); ..matches also SPACE CH
Next
From: Sean Kelly
Date:
Subject: Re: Updating multiple bool values crashes backend