On 07/11/2012 07:23 AM, Andy Chambers wrote:
I think I made a poor decision by having our application generate checkbook numbers on demand using sequences.
Sure did. Sequences are exempt from most transactional rules; that's why they're fast and lock-free.
I'm surprised to find that the only mention of this is at the very bottom of this page:
http://www.postgresql.org/docs/9.1/static/functions-sequence.html as it's an important property of sequences and one that shouldn't just be a footnote.
I'd use a real table for this job.
--
Craig Ringer