Re: About OIDs - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: About OIDs
Date
Msg-id 20030327212922.GD5030@dcc.uchile.cl
Whole thread Raw
In response to About OIDs  (Flower Sun <sun_2002_flower@yahoo.com>)
Responses Re: About OIDs  (Flower Sun <sun_2002_flower@yahoo.com>)
Re: About OIDs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Et put se mouve" (Galileo Galilei)


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: file in data doesn't correspond to any oid in pg_class?
Next
From: Tom Lane
Date:
Subject: Re: DeleteTransactionInProgress