Postgres Pro
Downloads
Home   >   mailing lists

Re: Utility of OIDs in postgres - Mailing list pgsql-general

From Richard Huxton
Subject Re: Utility of OIDs in postgres
Date
Msg-id 463842D4.3030407@archonet.com
Whole thread Raw
In response to Utility of OIDs in postgres  ("Jasbinder Singh Bali" <jsbali@gmail.com>)
Responses Re: Utility of OIDs in postgres
List pgsql-general
Tree view 
Jasbinder Singh Bali wrote:
> Hi,
>
> What would be the benefit of creating tables with OIDs as against one's not
> with OIDs
> Giving a unique identifier to each row inserted has some extra efficiency
> factor involved or what.

OIDs are used by the various system tables.
Historically, all user tables had them too.
There's no reason to use them in a new system - they offer no advantages
over an ordinary integer primary-key.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Postgres (selection of thesis topic)
Next
From: "Andrej Ricnik-Bay"
Date:
Subject: Re: STDERR vs. SYSLOG logging