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:03:37
Message-ID: 15615.1022612617@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Tim Wilson <wilson(at)visi(dot)com> writes:
> I used 'new_event' as the name of the newly created 'event' table. I
> subsequently renamed it back to 'event'. I've looked all through the
> database looking for rogue references to 'new_event', but I can't find
> any.

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

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tim Wilson 2002-05-28 19:13:16 Re: remnants of deleted table causing problems
Previous Message Tim Wilson 2002-05-28 17:36:03 remnants of deleted table causing problems