An Idea for OID conflicts

From: Gevik Babakhani <pgdev(at)xs4all(dot)nl>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: An Idea for OID conflicts
Date: 2006-09-18 17:53:56
Message-ID: 1158602036.5590.31.camel@voyager.truesoftware.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Folks,

I would like to have your thoughts on a solution for the duplicate OIDs.

I wanted to apply the uuid patch on a newly download source from the
CVS. Patching and "make install" went just okay but "make check" and
initdb failed to my surprise. A quick look at duplicate_oids showed that
almost all of the OIDs I got available from unused_oids were already in
use. So naturally I went "!!?! segmentation fault **!!?".

I can only imagine how time consuming this can be for the committers to
correct these manually.

I think we can solve this problem with the combination of the following
three steps.

1. When using new OIDs always start from a fixed number. For example
10000. This way the new OIDs are easy to recognize and the developer can
continue the work.
2. Always use the new OIDs sequentially.
3. Make a small utility that goes through a patch, finds the new OIDs
and changes them back to a value specified by the committer(s).

Would this be workable?

Regards,
Gevik.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2006-09-18 17:54:17 Re: 8.2 beta blockers
Previous Message Teodor Sigaev 2006-09-18 17:21:40 Re: Limited Sort