Re: SERIAL datatype - Mailing list pgsql-general

From Mark Roberts
Subject Re: SERIAL datatype
Date
Msg-id 1219681385.2099.4.camel@localhost
Whole thread Raw
In response to Re: SERIAL datatype  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: SERIAL datatype
List pgsql-general
On Thu, 2008-08-21 at 13:53 -0600, Scott Marlowe wrote:
> Regular SERIAL type is limited to a 32 bit int.  BIGSERIAL uses a 64
> bit int.

I think one of the things that would be offsetting is the size
difference between the two types (32 vs 64 bits, 5 foreign keys, and a
billion rows or so makes for alot of pain).

-Mark


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Dump/restore with bad data and large objects
Next
From: "Yuri Huitron Alvarado"
Date:
Subject: just work installation & configuration