Limit of sequence

Поиск
Список
Период
Сортировка
От Mourad EL HADJ MIMOUNE
Тема Limit of sequence
Дата
Msg-id 00b201c1818f$a2f90620$71a337c1@ensma.fr
обсуждение исходный текст
Ответ на Suitability of postgres for very high transaction volume  (Alex Avriette <a_avriette@acs.org>)
Ответы Re: Limit of sequence  (Holger Krug <hkrug@rationalizer.com>)
Re: Limit of sequence  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
Hello all,
I use sequence to generate an ID for each row by using a same sequence for
all tables (it's a same as an OID). I want know the limit of number
genereted by a sequence. Did sequence use short or long integer?
I use my own ID instead of system OID because I can't use it as foreign key.
I use now a 7.1.3 version of Postgres. Is the 7.2 version ready or not yet
and did it support the reference to an OID.
Thanks.
Mourad.



В списке pgsql-general по дате отправления:

Предыдущее
От: "Adam Fisher"
Дата:
Сообщение: referential integrity on existing table
Следующее
От: "Travis Bear"
Дата:
Сообщение: use BLOBS or use pointers to files on the filesystem?