Re: sequences and "addval('myseq', value)" - Mailing list pgsql-hackers

From Bruno Wolff III
Subject Re: sequences and "addval('myseq', value)"
Date
Msg-id 20040608144508.GA4716@wolff.to
Whole thread Raw
In response to Re: sequences and "addval('myseq', value)"  (pgsql@mohawksoft.com)
List pgsql-hackers
On Tue, Jun 08, 2004 at 10:18:42 -0400, pgsql@mohawksoft.com wrote:
> 
> If I understand correctly, and I've sort of just worked on this
> assumption, a sequence does not nessisarily produce a sequence of numbers.
> It produces a succession of numbers that are guarenteed to increase, but
> not nessisarily with a specific interval (usually one).

They are only guarenteed to increase within a single session and that assumes
that the sequence doesn't roll over. Some people may need to worry about
32 bit sequences rolling over.


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Question regarding dynamic_library_path
Next
From: Tom Lane
Date:
Subject: Re: cvs head : broken regression tests ?