"Martin Edlman" <edlman(at)fortech(dot)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