If OIDS are for the whole postgresql server, not for individual database.
You have to drop all the databases in order to reuse OIDS, I think, which is not good for those companys who let host company hosting their databases. Because there are many other companys using the same postgresql server at the same time. And you have no idea whether other companys' tables are created with OIDS or not.
I think OID is equivlent to Oracle ROWID which is 64bits right now. ROWID don't have exhaustion problem.
Dann Corbit <DCorbit@connx.com> wrote:
-----Original Message-----
From: Flower Sun [mailto:sun_2002_flower@yahoo.com]
Sent: Friday, March 28, 2003 9:13 AM
To: Dann Corbit; Pgsql Group
Subject: Re: [GENERAL] About OIDs
Hi, Dann,
Do you think every database within a postgresql server has its own
32bits OID to use?
>>
No. You can rely on them being present only if you build the tables
yourself.
Many other database systems have a similar idea. For instance, Oracle's
Rdb has a DBKEY.
In Codd's latest "Database Manifesto" he suggests doing away with them
(along with SQL itself).
I think he has been sitting in an ivory tower too long, but what do I
know.
<<
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Do you Ya hoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness,
live on your desktop!