Hi,

In the file large_object/inv_api.c there is a statement in the function
inv_create
which goes:

    file_oid=newoid() + 1;

later on a heap_create_with_catalog call is performed to create a heap
for the large object called xinv<file_oid>.

According to code (and the comments in the code) the assumption is that the
oid
of the heap_relation will be equal to the value of the variable file_oid.

This of course will only be the case if nobody else called newoid()
before the heap relation is created.

This might lead the large object implementation to confuse
large object relations with other relations.

According to me this is a bug. I'm I right?

Thanks,
Maurice



Fri, 6 Mar 1998 16:30:56 +0100
"Maurice Gittens" <mgittens@gits.nl>
newoid in invapi.c
On Fri, 6 Mar 1998, Maurice Gittens wrote:

> Hi,
> 
> In the file large_object/inv_api.c there is a statement in the function
> inv_create
> which goes:
> 
>     file_oid=newoid() + 1;
> 
> later on a heap_create_with_catalog call is performed to create a heap
> for the large object called xinv<file_oid>.
> 
> According to code (and the comments in the code) the assumption is that the
> oid
> of the heap_relation will be equal to the value of the variable file_oid.
> 
> This of course will only be the case if nobody else called newoid()
> before the heap relation is created.
> 
> This might lead the large object implementation to confuse
> large object relations with other relations.
> 
> According to me this is a bug. I'm I right?

Yes, and no. LargeObjects are supposed to run within a transaction (if you
don't then some fun things happen), and (someone correct me if I'm wrong)
if newoid() is called from within the transaction, it is safe? 

-- 
Peter T Mount  petermount@earthling.net or pmount@maidast.demon.co.uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk


Sun, 8 Mar 1998 19:43:25 +0000 (GMT)
Peter T Mount <psqlhack@maidast.demon.co.uk>
Re: [HACKERS] newoid in invapi.c