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