MaRCeLO PeReiRA wrote:
How can I now (for sure) with value was generated by the sequence to fill the field ID?
(There is lots of users using the software at the same time, so I am not able to use the last_value() function on the sequence.)
Yes you are nextval()/currval() are multi-user safe. They return the next/current value *in the current connection*.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
