Re: Utility of OIDs in postgres

From: Richard Huxton <dev(at)archonet(dot)com>
To: Jasbinder Singh Bali <jsbali(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Utility of OIDs in postgres
Date: 2007-05-02 07:50:44
Message-ID: 463842D4.3030407@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrej Ricnik-Bay 2007-05-02 08:58:50 Re: STDERR vs. SYSLOG logging
Previous Message Richard Huxton 2007-05-02 07:48:08 Re: Postgres (selection of thesis topic)