sequence max values

From: Charlie Crissman <CCrissman(at)nbibx(dot)com>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: sequence max values
Date: 2000-11-07 20:51:46
Message-ID: 7309940DCB64D411A91B00508BD94F5708244B@nbimail1.jax.nbibx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)nbibx(dot)com <mailto:CCrissman(at)nbibx(dot)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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2000-11-07 21:13:54 Re: sequence max values
Previous Message Charlie Crissman 2000-11-07 19:01:56 tablespace?