Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Problem with transactions


  • From: "Matthijs Melissen" <melissen(at)phil(dot)uu(dot)nl>
  • To: <pgsql-general(at)postgresql(dot)org>
  • Subject: Problem with transactions
  • Date: Tue, 27 Mar 2007 00:05:56 +0200
  • Message-id: <01ce01c76ff2$ee3d1de0$5ee26191(at)Matthijs>

I want two users to execute the following queries:

1) delete from forum where id = 'A';
1) insert into forum (id, name) values ('A', 'testa');

2) delete from forum where id = 'A';
2) insert into forum (id, name) values ('A', 'testb');

id is a unique key. The numbers designate the user (1 and 2). The problem is that I don't know in which order the queries are executed (I only know each user executes its DELETE query before the INSERT query). I can't use UPDATE because I don't know in advance that there exist a row with id A.

How do I prevent the queries from being executed in the wrong order and thus causing an 'duplicate key violates unique constraint' error?



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group