dbTalk Databases Forums  

[BUGS] Deferred Referential Constraint: Changing Referenced Key

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] Deferred Referential Constraint: Changing Referenced Key in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Daniel Cristian Cruz
 
Posts: n/a

Default [BUGS] Deferred Referential Constraint: Changing Referenced Key - 06-29-2005 , 01:07 PM






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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply With Quote
  #2  
Old   
Stephan Szabo
 
Posts: n/a

Default Re: [BUGS] Deferred Referential Constraint: Changing Referenced Key - 06-29-2005 , 01:16 PM







Quote:
-----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...0154.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 majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.