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.
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? |