On 9/14/07, Panagiotis Pediaditis <pped@xxxxxxxxxxxx> 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?
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
