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

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Cc: "Grigory Zinin" <Grigory(dot)Zinin(at)com(dot)mels(dot)ru>
Subject: Re: BUG #4357: SERIAL pseudotype and related SEQUENCE object
Date: 2008-08-15 11:32:14
Message-ID: 200808151432.15654.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2008-08-15 15:27:29 Re: BUG #4340: SECURITY: Is SSL Doing Anything?
Previous Message Peter Eisentraut 2008-08-15 11:30:11 Re: xmlAgg not found..