Re: SERIAL datatype

From: Mark Roberts <mailing_lists(at)pandapocket(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Peter Billen <peter(at)clueless(dot)be>, pgsql-general(at)postgresql(dot)org
Subject: Re: SERIAL datatype
Date: 2008-08-25 16:23:05
Message-ID: 1219681385.2099.4.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yuri Huitron Alvarado 2008-08-25 16:46:52 just work installation & configuration
Previous Message Tom Lane 2008-08-25 16:14:41 Re: Dump/restore with bad data and large objects