> -----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. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly