Skip site navigation (1) Skip section navigation (2)

Re: remnants of deleted table causing problems

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tim Wilson <wilson(at)visi(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: remnants of deleted table causing problems
Date: 2002-05-28 19:22:51
Message-ID: 15868.1022613771@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Tim Wilson <wilson(at)visi(dot)com> writes:
>> I'd bet on a referential integrity trigger causing the problem.  Up till
>> very recently, RENAME TABLE wasn't smart enough to adjust RI trigger
>> parameters.  (Don't recall if the fix is in 7.2 or not; it may only be
>> in development sources.)

> So I should drop the 'location_exists' constraint in the 'event' table
> and recreate it?

If it is RI triggers, you'll need to drop the triggers manually ---
there's no support for this in ALTER TABLE :-(.  I believe you can
find some discussion of how to do it on techdocs.postgresql.org.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Peter DarleyDate: 2002-05-28 21:36:39
Subject: Changing ownership of objects
Previous:From: Tim WilsonDate: 2002-05-28 19:13:16
Subject: Re: remnants of deleted table causing problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group