Re: [HACKERS] newoid in invapi.c
Peter T Mount <psqlhack@maidast.demon.co.uk>
From: Peter T Mount <psqlhack@maidast.demon.co.uk>
To: Maurice Gittens <mgittens@gits.nl>
Cc: PostgreSQL-development <hackers@postgresql.org>
Date: 1998-03-08T19:43:25Z
Lists: pgsql-hackers
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