Re: [BUGS] BUG #5770: Foreign key violation after insert

2010-11-26 Thread Martin Edlman
-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-consid

Re: [BUGS] BUG #5770: Foreign key violation after insert

2010-11-25 Thread Tom Lane
"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

[BUGS] BUG #5770: Foreign key violation after insert

2010-11-25 Thread Martin Edlman
The following bug has been logged online: Bug reference: 5770 Logged by: Martin Edlman Email address: edl...@fortech.cz PostgreSQL version: 9.0.1 Operating system: Scientific Linux 5.5 (RHEL) Description:Foreign key violation after insert Details: Hello, I have two