Received: from informactis.com ([62.161.175.1])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f6Q9HQf11168
	for <pgsql-general@postgresql.org>;
	Thu, 26 Jul 2001 05:17:26 -0400 (EDT)
	(envelope-from ssa@informactis.com)
Received: from steve (informactisatm-nat.clients.easynet.fr [212.11.21.91])
	by informactis.com (8.9.3/8.9.3) with SMTP id LAA16941
	for <pgsql-general@postgresql.org>; Thu, 26 Jul 2001 11:18:48 +0200
From: "Steve SAUTETNER" <ssa@informactis.com>
To: <pgsql-general@postgresql.org>
Subject: concurent updates
Date: Thu, 26 Jul 2001 11:19:36 +0200
Message-ID: <BKEHJDOFOAHJBCOBCHJGKEHACCAA.ssa@informactis.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
X-Mimeole: Produced By Microsoft MimeOLE V5.00.2919.6700
Importance: Normal
X-Archive-Number: 200107/938
X-Sequence-Number: 13058

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.