Re: BUG #5770: Foreign key violation after insert

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Tom,

> "Martin Edlman"  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?

Thank you very much for help. It works now. You're right, I've converted
from EXECUTE to plain INSERT and I forgot to remove quote_literal() and
then I didn't see that this was the problem. I'm glad that the problem was
on my side and not in PgSQL.

Regards, Martin Edlman
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAkzvdVQACgkQqmMakYm+VJ96iACeP4PpQuiXBxe7ylAJTHBH4Npl
+n4AoINh4YeayAUcG3Z8wumoROwpx8bj
=qfuC
-----END PGP SIGNATURE-----