Re: sequences and "addval('myseq', value)"

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: pgsql(at)mohawksoft(dot)com
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: sequences and "addval('myseq', value)"
Date: 2004-06-08 14:45:08
Message-ID: 20040608144508.GA4716@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jun 08, 2004 at 10:18:42 -0400,
pgsql(at)mohawksoft(dot)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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-06-08 14:46:38 Re: cvs head : broken regression tests ?
Previous Message Bruce Momjian 2004-06-08 14:37:55 Re: [pgsql-hackers-win32] Failures with windows port