> >People who have not studied the documentation frequently make that >claim. *There is no such risk* (unless A and B are interleaving their >commands on a single database connection, in which case they have lots >worse risks of conflicts than this one). See >http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/functions-sequence.html > > regards, tom lane
Point taken. I've worked on web-apps which use a single JDBC connection per user session where the overlap could occur, but as you say there are far greater issues involved for such session-based connections. -- Joel Stevenson Bear River Associates, Inc. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html