Re: BUG #5770: Foreign key violation after insert

From: Martin Edlman <edlman(at)fortech(dot)cz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5770: Foreign key violation after insert
Date: 2010-11-26 08:52:36
Message-ID: 4CEF7554.3020305@fortech.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Hi Tom,

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

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-----

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message tv 2010-11-26 12:54:19 memory leak in xml2 contrib module
Previous Message Fujii Masao 2010-11-26 04:25:19 Re: Re: [BUGS] BUG #5650: Postgres service showing as stopped when in fact it is running