Re: OIDs as keys - Mailing list pgsql-performance

From Richard Huxton
Subject Re: OIDs as keys
Date
Msg-id 200302261610.13115.dev@archonet.com
Whole thread Raw
In response to Re: OIDs as keys  (daniel alvarez <d-alvarez@gmx.de>)
List pgsql-performance
On Wednesday 26 Feb 2003 2:59 pm, daniel alvarez wrote:
>
> Why should user-defined tables have OIDs by default? Other DBMS use ROWIDs
> as the physical storage location used for pointers in index leafs, but this
> is equivalent
> to Postgres TIDs. To the user an OID column is not different than any other
> column
> he can define himself. I'd find it more natural if the column wasn't there
> at all.

I believe the plan is to phase them out, but some people are using them, so
the default is still to create them. Imagine if you were using OIDs as keys
and after a dump/restore they were all gone...
--
  Richard Huxton

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: OIDs as keys
Next
From: Josh Berkus
Date:
Subject: Re: OIDs as keys