Thread: Deferred Referential Constraint: Changing Referenced Key
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi there, I was wondering if it is a bug or a feature. When I change a key on a referenced table, and there is a foreign key deferred constraint, it triggers imediately, not at the end of transaction. If I change the reference first, it works as expected. Someone had the same problem: http://search.postgresql.org/cgi-bin/s.cgi/archives.search?cs=utf-8&q=deferred+constraint+referenced+key&ch=http:%2F%2Farchives.postgresql.org%2Fpgsql-bugs%2F2001-03%2Fmsg00154.php&fm=on Where do I get if this problem has a solution or it has been seen? Daniel Cristian -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCwrfG6TuR6lz8YgMRAhirAJ44qco/kIo/zuCCuVZcezmea4e2lwCfQPjj /lTdhdrWzjha4MZhri/sT0s= =uJE2 -----END PGP SIGNATURE-----
> -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi there, > > I was wondering if it is a bug or a feature. When I change a key on a > referenced table, and there is a foreign key deferred constraint, it > triggers imediately, not at the end of transaction. > > If I change the reference first, it works as expected. Someone had the > same problem: > > http://search.postgresql.org/cgi-bin/s.cgi/archives.search?cs=utf-8&q=deferred+constraint+referenced+key&ch=http:%2F%2Farchives.postgresql.org%2Fpgsql-bugs%2F2001-03%2Fmsg00154.php&fm=on > > Where do I get if this problem has a solution or it has been seen? The example in that message works for me in recent versions. You're going to need to give a version and standalone example before we're going to be able to help you.