Re: Updating multiple bool values crashes backend

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sean Kelly <S(dot)Kelly(at)ncl(dot)ac(dot)uk>
Cc: pgsql-bugs(at)postgreSQL(dot)org
Subject: Re: Updating multiple bool values crashes backend
Date: 2000-10-26 15:27:22
Message-ID: 5781.972574042@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Sean Kelly <S(dot)Kelly(at)ncl(dot)ac(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sean Kelly 2000-10-26 16:09:19 Re: Updating multiple bool values crashes backend
Previous Message Stephan Szabo 2000-10-26 15:19:47 Re: Select where (upper(xy)~'.CH'); ..matches also SPACE CH