Re: OID Usage - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: OID Usage
Date
Msg-id 20050114232438.GB29663@dcc.uchile.cl
Whole thread Raw
In response to Re: OID Usage  (Bo Lorentsen <bl@netgroup.dk>)
Responses Re: OID Usage
List pgsql-general
On Sat, Jan 15, 2005 at 12:06:41AM +0100, Bo Lorentsen wrote:

> Ok, Tom told me about the same :-(  But why are oid's still in PG, that
> are they good for ? Will there be a real unique row id, like there is in
> Oracle, or will this be keept as an internal value only ?

Most system catalogs use OIDs as primary keys.  So they cannot just
disappear.  But on user tables, there's not a lot of use for them IMHO.

There's no internal row id on Postgres; having one would mean more
storage requirements.  If you want one, you know where to get it ... if
not, you may as well save the space.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"No hay cielo posible sin hundir nuestras raíces
 en la profundidad de la tierra"                        (Malucha Pinto)

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: OID Usage
Next
From: Martijn van Oosterhout
Date:
Subject: Re: [HACKERS] Much Ado About COUNT(*)