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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs