Thread

1. Re: Updating multiple bool values crashes backend

   Darcy Buskermolen <darcy@ok-connect.com> — 2000-10-27T18:55:24Z

   Could it also be the result of a Cluster operation? I've seen strange
   things related to functions/triggers on tables that I've clustered.
   
   
   >> 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
   >
   >
   
   

2. Re: Updating multiple bool values crashes backend

   Sean Kelly <s.kelly@ncl.ac.uk> — 2000-10-30T10:41:16Z

   On Fri, 27 Oct 2000 11:55:24 -0700, Darcy Buskermolen said:
   
   > Could it also be the result of a Cluster operation? I've seen strange
   >  things related to functions/triggers on tables that I've clustered.
   
   	Personally for me it turned out to be, as Tom said, the
   renaming of a table involving foreign keys.  I renamed the table back
   to what it was, dropped it, and then recreated the new one with new
   foreign keys.
   
   	Thanks,
   
   -- 
   Sean Kelly <S.Kelly@ncl.ac.uk>
   "If 99% is good enough, then gravity will not work for 14 minutes
    every day."