Re: BUG #5770: Foreign key violation after insert

"Martin Edlman" <edlman@fortech.cz> writes:
> I encountered this problem during migration of the database from PgSQL 8.4
> (where it works) to PgSQL 9.0.1.

For me, this example fails on both 8.4 and 9.0.  It works on both after
removing the ill-considered quote_literal call here:

>     INSERT INTO tmp.amavis_user (id, email, priority, policy_id)
>     VALUES (NEW.id, quote_literal(NEW.email), prio, 1);

Perhaps you tried to migrate away from using EXECUTE at the same time
you were converting to 9.0?

            regards, tom lane