From: | wsheldah(at)lexmark(dot)com |
---|---|
To: | "Steve SAUTETNER" <ssa(at)informactis(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: concurent updates |
Date: | 2001-07-26 15:24:05 |
Message-ID: | 200107262036.QAA24005@interlock2.lexmark.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Why do you need to change the value of the id field?? The id field shouldn't
have any meaning attached to it beyond the fact that it uniquely identifies a
row in the table, and of course its usage as a foreign key when it serves that
role. If you just want to change what numbers get assigned, I think you can
update the SEQUENCE that table1 uses.
If you really need to do this, you might have better luck using a trigger to do
a cascading update from table1 to table2, and then ONLY issue the update to
table1, counting on the trigger to update table2.
"Steve SAUTETNER" <ssa%informactis(dot)com(at)interlock(dot)lexmark(dot)com> on 07/26/2001
05:19:36 AM
To: pgsql-general%postgresql(dot)org(at)interlock(dot)lexmark(dot)com
cc: (bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: [GENERAL] concurent updates
hi everybody !
I've got a little problem when updating a primary key in two table
where the primary key of the one is a foreign key from the second :
here are the 2 tables :
create table table1 (id int primary key, col1 int);
create table table2 (id int primary key references table1(id), col2 int);
and the 2 updates :
1) update table2 set id = 1001 where id = 1;
2) update table1 set id = 1001 where id = 1;
i can't execute them separately because of an integrity constraint
violation.
i've got the same error in a BEGIN / COMMIT block containing the updates.
Does any one see how two help me ?
thanks.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
From | Date | Subject | |
---|---|---|---|
Next Message | Andre Schnabel | 2001-07-26 16:26:27 | Re: concurent updates |
Previous Message | Justin Clift | 2001-07-26 15:03:31 | Re: Hardware Recommendations |