| From: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
| Cc: | "Weber, Johann (ISS Kassel)" <jweber(at)iss(dot)net>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Atomar SQL Statement |
| Date: | 2006-07-08 04:17:12 |
| Message-ID: | 6738B213-C52B-4F71-9134-85B45A4922B9@seespotcode.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Jul 7, 2006, at 14:07 , Stephan Szabo wrote:
> I don't think he is, because I don't think the issue is the SERIAL
> behavior, but instead the NOT EXISTS behavior.
I guess I should have been clearer in the issue I was addressing,
which is whether or not a separate transaction could slip in and
interrupt his transaction, which my understanding is that it can't. I
personally would handle the insert if necessary/select in a different
way, but I don't see anything necessarily wrong with his statement. I
assumed that he does have a UNIQUE constraint on the email address
field. I should definitely know better than to make assumption.
Sorry, Johann, for not addressing your complete email, but rather
just a portion of it.
Michael Glaesemann
grzm seespotcode net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma Jr | 2006-07-08 06:34:57 | Celko's Puzzle Number 5 |
| Previous Message | Rodrigo De Leon | 2006-07-08 01:24:07 | Re: SELECT substring with regex |