Postgres Pro
Downloads
Home   >   mailing lists

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

From Gregory Wood
Subject Re: oids vs. serial question
Date
Msg-id 012f01c1c378$b0a2ddc0$7889ffcc@comstock.com
Whole thread Raw
In response to oids vs. serial question  (Alex Rice <alex_rice@arc.to>)
Responses Re: oids vs. serial question  (Sean Chittenden <sean@chittenden.org>)
List pgsql-general
Tree view 
> 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).

Greg

pgsql-general by date:

Previous
From: "Gregory Wood"
Date:
Subject: Re: alter table question
Next
From: "Gregory Wood"
Date:
Subject: Re: Arrays in pgsql