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