Title: ________________________________
If I'm using transactions (not autocommit), are sequences atomic?

In other words, after inserting a record to a table that 
uses sequence A, am I guaranteed that select last_value on 
sequence A is atomic, and cannot be interfered with by other 
transactions using that same sequence? Sequence A is used by
several tables.

Thanks,
Jodi


-

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
[EMAIL PROTECTED]


 

 

 

Reply via email to