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

From Bruce Momjian
Subject Re: Updating multiple bool values crashes backend
Date
Msg-id 200010270302.XAA19947@candle.pha.pa.us
Whole thread Raw
In response to Re: Updating multiple bool values crashes backend  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Updating multiple bool values crashes backend
List pgsql-bugs
Do we need a TODO here?

> 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
>


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: \df causes an ERROR: Function oid8types(oidvector) does not exists
Next
From: Tom Lane
Date:
Subject: Re: Updating multiple bool values crashes backend