Sizes of sequences and serials (fwd)

Поиск
Список
Период
Сортировка
От Elein Mustain
Тема Sizes of sequences and serials (fwd)
Дата
Msg-id 200209270109.g8R19Rgj013849@tulip.norcov.com
обсуждение исходный текст
Список pgsql-general
According to the documentation, it looks like sequences
are always stored as bigints (if the platform supports them).

Serials, though, seem to be able to be declared as serial
with integer storage or serial8 for bigint storage.

Is the storage for ordinary serials really an int and not
a big int?  Is there a way to create a sequence stored
as an int instead of a big int?  For example by setting
the maximun size?

thanks,
elein@norcov.com



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

Предыдущее
От: "Peter Kovacs"
Дата:
Сообщение: Re: [JDBC] Prepared statement performance...
Следующее
От: Andriy Tkachuk
Дата:
Сообщение: Re: query speed depends on lifetime of frozen db?