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

OID Question

From: Terry Lee Tucker <terry(at)esc1(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: OID Question
Date: 2004-11-11 15:04:30
Message-ID: 200411111004.30510.terry@esc1.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
Greetings,

Here is a simple question:

Is it ok to put a unique index on the oid for my tables? We are in the process 
of moving from Progress Software to PostgreSQL. In the Progress world, you 
can always uniquely, and quickly find a record by using their version of oid, 
which is recid.  I remember reading somewhere that the oid could be 
duplicated across the cluster, but would not be duplicated in a single table. 
Maybe I dreamed it. What is the recommendation regarding this and why?

Version:
PostgreSQL 7.4.6 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 
20030502 (Red Hat Linux 3.2.3-42)

Thanks for your input...
-- 

 Work: 1-336-372-6812
 Cell: 1-336-363-4719
email: terry(at)esc1(dot)com

Responses

pgsql-novice by date

Next:From: Richard HuxtonDate: 2004-11-11 17:50:00
Subject: Re: OID Question
Previous:From: Sean DavisDate: 2004-11-11 12:39:40
Subject: ER Diagrams

pgsql-general by date

Next:From: Bob PowellDate: 2004-11-11 15:31:28
Subject: making another super user other than postgres
Previous:From: David ParkerDate: 2004-11-11 14:49:12
Subject: checkpoints

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