sequence max values - Mailing list pgsql-admin

From Charlie Crissman
Subject sequence max values
Date
Msg-id 7309940DCB64D411A91B00508BD94F5708244B@nbimail1.jax.nbibx.com
Whole thread Raw
Responses Re: sequence max values  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-admin
I have created a sequence.  It appears, although I cant find this
documented, that the max value we can have in our sequence is around
2,140,000,001

I say 'around' because it would take me a while to figure out the exact max.
It works at 2,140,000,001  but fails at  2,150,000,001

Can anyone tell me (or show me where to look it up in the documentation)
what the range of values is for a sequence?

Thanks, Charlie Crissman

Charlie Crissman
Sr. Oracle DBA
Oracle Certified Professional DBA
No Boundaries Network, Inc.
904-245-6839
Pager 904-840-3684
mailto:CCrissman@nbibx.com <mailto:CCrissman@nbibx.com>
Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their
shoes.


pgsql-admin by date:

Previous
From: Charlie Crissman
Date:
Subject: tablespace?
Next
From: Peter Eisentraut
Date:
Subject: Re: sequence max values