Re: BUG #4357: SERIAL pseudotype and related SEQUENCE object - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: BUG #4357: SERIAL pseudotype and related SEQUENCE object
Date
Msg-id 200808151432.15654.peter_e@gmx.net
Whole thread Raw
In response to BUG #4357: SERIAL pseudotype and related SEQUENCE object  ("Grigory Zinin" <Grigory.Zinin@com.mels.ru>)
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: xmlAgg not found..
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #4340: SECURITY: Is SSL Doing Anything?