Jeffrey Melloy <jmelloy(at)visualdistortion(dot)org> writes:
> Recently, I decided to rename one of my schemas from "adium" to "im".
> Then, all inserts started failing.
> I recreated a couple functions, changed the search path, and all inserts
> are still failing due to referential integrity checks going against
> "adium" still. Is there any way I can fix this, short of manually
> dropping every constraint and recreating them?
I couldn't replicate this ... AFAICS the RI triggers reference tables by
OID, not name. What PG version are you using? Can you give a
self-contained test case?
regards, tom lane