| From: | Andrew Snow <andrew(at)modulus(dot)org> |
|---|---|
| To: | Sean Chittenden <sean(at)chittenden(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: oids vs. serial question |
| Date: | 2002-03-05 05:48:30 |
| Message-ID: | 20020305164830.A312@esper.modulus.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-03-05 05:49:39 | Re: FATAL 2: RelationPutHeapTuple: failed to add tuple |
| Previous Message | Sean Chittenden | 2002-03-05 05:45:53 | Re: oids vs. serial question |