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
---------------------------(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
