From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Sim Zacks <sim(at)compulab(dot)co(dot)il> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: transaction confusion |
Date: | 2006-09-17 10:32:21 |
Message-ID: | 20060917103221.GD14893@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sun, Sep 17, 2006 at 10:32:12AM +0200, Sim Zacks wrote:
> I have a function that deletes all the values in a table and then
> inserts the data again. If this function is run in 2 sessions at the
> same time then it populates it twice, giving me a unique value error,
> because one of the fields is supposed to be unique.
<snip>
> Does this make any sense?
Not overly much to me anyway. Could you provide some cut-and-paste
output from a psql session so we can see the actual commands you're
typing. It's possible the actual deletes and inserts are coded in a way
to cause a problem...
Hope this helps,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
From | Date | Subject | |
---|---|---|---|
Next Message | Sim Zacks | 2006-09-17 15:01:06 | Re: transaction confusion |
Previous Message | Martijn van Oosterhout | 2006-09-17 10:22:42 | Re: PostgreSQL installed in non-standard Directory |