Re: Fw: OID

From: Joe Conway <mail(at)joeconway(dot)com>
To: Jodi Kanter <jkanter(at)virginia(dot)edu>
Cc: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Fw: OID
Date: 2002-08-16 20:40:52
Message-ID: 3D5D6354.4060507@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Jodi Kanter wrote:
> Does anyone have a comment on the email below? Is there a general
> consensus on whether or not to use OIDs with version 7.2?

<snip>

>
> Can anyone point me to some documentation on the use of OIDs? Why might
> I need them? How to remove them in version 7.2? ..etc...

I think you're best to avoid using them. They are primarily for internal
system use. If you need an incrementing integer field, create your own
with SERIAL, or integer field and a sequence.

To create a table without oids, see:
http://www.postgresql.org/idocs/index.php?sql-createtable.html

Joe

In response to

  • Fw: OID at 2002-08-16 20:25:02 from Jodi Kanter

Responses

  • Re: Fw: OID at 2002-08-18 17:24:15 from Daniel L Banta
  • Re: Fw: OID at 2002-08-19 07:10:08 from Jules Alberts

Browse pgsql-admin by date

  From Date Subject
Next Message Alberto González 2002-08-16 21:32:55 Problems with pg_dump
Previous Message John Gunther 2002-08-16 20:34:08 Re: Fw: OID