Re: Locking entire database - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Locking entire database
Date
Msg-id dcc563d10709140921y7a9e1f84y72a471aa92effa86@mail.gmail.com
Whole thread Raw
In response to Re: Locking entire database  (Panagiotis Pediaditis <pped@ics.forth.gr>)
Responses Re: Locking entire database  (Panagiwths Pediadiths <pped@ics.forth.gr>)
List pgsql-general
On 9/14/07, Panagiotis Pediaditis <pped@ics.forth.gr> wrote:
> A simpler example,
>     In the context of one transaction i do many queries of the form
>           INSERT INTO table value WHERE value NOT IN TABLE;
>
> If i have 2 processes running the same 100s of these at the same time i
> end up with duplicates.
> Even with isolation set to serializable
> any ideas?

Unique index?

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Inherited FK Indexing
Next
From: Alan Hodgson
Date:
Subject: Re: Inherited FK Indexing