Re: BUG #4357: SERIAL pseudotype and related SEQUENCE object

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: BUG #4357: SERIAL pseudotype and related SEQUENCE object
Дата
Msg-id 200808151432.15654.peter_e@gmx.net
обсуждение исходный текст
Ответ на BUG #4357: SERIAL pseudotype and related SEQUENCE object  ("Grigory Zinin" <Grigory.Zinin@com.mels.ru>)
Список pgsql-bugs
Am Friday, 15. August 2008 schrieb Grigory Zinin:
> We can create SERIAL field. But INTEGER type will be really set. It's well
> known that INTEGER field doesn't match values more than 4 bytes. But
> related SEQUENCE object has a 8 byte value.
> It looks strange for me that 4 bytes of these 8 byte value will never be
> used.
> Is it bug or feature?

Well, it is that way by design, because most people will want the faster int4
type for their key fields.  If you want a bigger type, you have of course
bigserial available.

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: xmlAgg not found..
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #4340: SECURITY: Is SSL Doing Anything?