> > "You say nextval() + write, I say write + currval()..." > >So long as a given application does not mix the two approaches, everything >should be fine.
Though, if you have multiple clients inserting into the table, there is a chance that between client A inserting the record and then calling currval(), client B could have performed an insert, in which case client A gets the value of client B's record. 'nextval() + write' avoids this possible overlap. -- 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
