Skip site navigation (1) Skip section navigation (2)

Re: OIDs as keys

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: daniel alvarez <d-alvarez(at)gmx(dot)de>,Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: OIDs as keys
Date: 2003-02-26 17:17:24
Message-ID: 200302260917.24500.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Daniel,

> There can also be some problems when using replication, because one needs
> to make
> sure that OIDs are the same on all machines in the cluster.

See the "uniqueidentifier" contrib package if you need a universally unique id 
for replication.

> I'd find it more natural if the column wasn't there
> at all.

Probably by Postgres 8.0, it won't be.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

pgsql-performance by date

Next:From: Christopher Kings-LynneDate: 2003-02-27 01:19:32
Subject: Re: Index File growing big.
Previous:From: Richard HuxtonDate: 2003-02-26 16:10:13
Subject: Re: OIDs as keys

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group