sequence max values

Поиск
Список
Период
Сортировка
От Charlie Crissman
Тема sequence max values
Дата
Msg-id 7309940DCB64D411A91B00508BD94F5708244B@nbimail1.jax.nbibx.com
обсуждение исходный текст
Ответы Re: sequence max values  (Peter Eisentraut <peter_e@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: Charlie Crissman
Дата:
Сообщение: tablespace?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: sequence max values