Re: remnants of deleted table causing problems

Tim Wilson <wilson@visi.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