Re: OID - Mailing list pgsql-novice

From Manfred Koizar
Subject Re: OID
Date
Msg-id hq5o2vo97kljcuckf9kqq3ja9p2651fm5l@4ax.com
Whole thread Raw
In response to OID  ("Chris Boget" <chris@wild.net>)
List pgsql-novice
On Mon, 20 Jan 2003 08:28:22 -0600, "Chris Boget" <chris@wild.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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: UNION?
Next
From: "Chris Boget"
Date:
Subject: Re: OID