On Jul 7, 2006, at 7:55 , Weber, Johann (ISS Kassel) wrote:
> My concern: in a multi threaded environment, can a second thread
> interrupt this statement and eventually insert the same email
> address in
> the table with a different id? Or is this statement atomar?
You're safe. Take a look at the FAQ entries on SERIAL:
http://www.postgresql.org/docs/faqs.FAQ.html#item4.11.2
Hope this helps.
Michael Glaesemann
grzm seespotcode net