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

Re: heap_create with OID?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: heap_create with OID?
Date: 2000-07-04 06:57:36
Message-ID: 26430.962693856@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
> I am wondering if anyone can see an immediate problem in creating a function:
>     heap_create_oid
> which is just like heap_create, but takes an oid arg. This oid (assuming
> it's free) would be used to create the object.

How exactly do you propose to determine that the OID is free?
If the requested OID is greater than the current OID counter, how
will you prevent a future conflict?

There's no inherent problem in forcing a particular choice of OID;
initdb does it on every run.  The trick is to avoid a conflict of
OID assignments.

My own feeling is that the current LO setup is fundamentally flawed
by its reliance on specific OID values, and that the right answer is
to find a way to avoid that.  contrib/lo might provide some food for
thought here (although it's clearly not the whole answer either).

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2000-07-04 07:23:28
Subject: Re: [GENERAL] Re: [HACKERS] proposed improvements to PostgreSQL license
Previous:From: Chris BitmeadDate: 2000-07-04 06:44:32
Subject: Re: heap_create with OID?

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