Re: oids vs. serial question - Mailing list pgsql-general

From Andrew Snow
Subject Re: oids vs. serial question
Date
Msg-id 20020305164830.A312@esper.modulus.org
Whole thread Raw
In response to Re: oids vs. serial question  (Sean Chittenden <sean@chittenden.org>)
List pgsql-general


On Mon, Mar 04, 2002 at 09:20:43PM -0800, Sean Chittenden wrote:
> > > as far as I understood the thing, take OIDs as 'internal' (they are
> > > unique all over all databases) and do not use them to organize your
> > > data.
> >
> > I think that sums it up nicely.
> >
> > > Is SERIAL still INT4 in v7.2?
> >
> > Yes, but there's now a BIGSERIAL (or SERIAL8 if you prefer).
>
> OH COOL!!!!  Very useful!  Is that in the ever famous, "7.2 docs" that
> are still pending release?  ::hint hint::  -sc


http://www.postgresql.org/users-lounge/docs/7.2/postgres/datatype.html#DATATYPE-SERIAL



- Andrew



pgsql-general by date:

Previous
From: Sean Chittenden
Date:
Subject: Re: oids vs. serial question
Next
From: Tom Lane
Date:
Subject: Re: FATAL 2: RelationPutHeapTuple: failed to add tuple