Re: About OIDs

> -----Original Message-----
> From: Alvaro Herrera [mailto:alvherre@dcc.uchile.cl]
> Sent: Thursday, March 27, 2003 1:29 PM
> To: Flower Sun
> Cc: Pgsql Group
> Subject: Re: [GENERAL] About OIDs
>
>
> On Thu, Mar 27, 2003 at 12:42:37PM -0800, Flower Sun wrote:
>
> > (1) I found system tables are all created without OIDs.
>
> There's no way to do this.  All system tables have OIDs.
>
> > But the default behavior of creating user tables are with OIDs. Is
> > there any benefit to create user tables with OIDs?
>
> No, unless you explicitly use them.

They are very handy for our ODBC driver.  It ensures that there is
always some sort of unique identifier for any table, even if the
designer did not create a primary key.  (Sure, that's a naughty no-no,
but it is astonishing how often it happens).  At any rate, some complex
joins can be sped up enormously by the existence of Odes.