| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Bo Lorentsen <bl(at)netgroup(dot)dk> |
| Cc: | "pgsql-general postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: OID Usage |
| Date: | 2005-01-14 23:24:38 |
| Message-ID: | 20050114232438.GB29663@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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[(at)]dcc(dot)uchile(dot)cl>)
"No hay cielo posible sin hundir nuestras raíces
en la profundidad de la tierra" (Malucha Pinto)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Terry Lee Tucker | 2005-01-14 23:34:38 | Re: OID Usage |
| Previous Message | Martijn van Oosterhout | 2005-01-14 23:17:42 | Re: OID Usage |