Re: OID

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: "Chris Boget" <chris(at)wild(dot)net>
Cc: "PGSql Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: OID
Date: 2003-01-20 15:47:35
Message-ID: hq5o2vo97kljcuckf9kqq3ja9p2651fm5l@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Mon, 20 Jan 2003 08:28:22 -0600, "Chris Boget" <chris(at)wild(dot)net>
wrote:
>Could someone explain what this is

A database wide 32 bit identifier, automatically assigned to each new
tuple, unless you created the table WITHOUT OIDS or (as of 7.3) you
created the table by CREATE TABLE AS ... (see recent discussion on
-hackers: "default to WITHOUT OIDS"). OID is not guaranteed to be
unique, because it can roll over, and its use as a PK for user tables
is discouraged.

> and what it's used for?

It's heavily used for identifying internal objects. For user tables
it is only overhead, unless you make explicit use of it.

Servus
Manfred

In response to

  • OID at 2003-01-20 14:28:22 from Chris Boget

Responses

  • Re: OID at 2003-01-20 15:53:38 from Chris Boget

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-01-20 15:48:22 Re: UNION?
Previous Message Manfred Koizar 2003-01-20 15:34:22 Re: UNION?