Re: oids

From: Erik Jones <erik(at)myemma(dot)com>
To: Bob Pawley <rjpawley(at)shaw(dot)ca>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: oids
Date: 2008-02-11 18:29:47
Message-ID: A698CF4F-C23B-433C-B3FD-F0F7C95B35AF@myemma.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Feb 11, 2008, at 12:15 PM, Bob Pawley wrote:

> I'm running Postgresql 8.2 on Windows.
>
> If I create a table 'without oids' are oids still in use behind the
> scenes??

Yes and no. WITHOUT OIDS specifies that you don't want each row to
get its own oid. You will often here of "a table's oid" and what
that is is the oid of the pg_class entry for that table. The default
when creating tables is WITHOUT OIDS and you should leave it that way.

Erik Jones

DBA | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com

In response to

  • oids at 2008-02-11 18:15:40 from Bob Pawley

Responses

  • Re: oids at 2008-02-11 18:38:55 from Bob Pawley

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2008-02-11 18:38:55 Re: oids
Previous Message Martijn van Oosterhout 2008-02-11 18:23:53 Re: oids