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

RE: [BUG] calling lo_creat()

From: "Barnes, Sandy (Sandra)" <Sandy(dot)Barnes(at)Honeywell(dot)com>
To: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: RE: [BUG] calling lo_creat()
Date: 2000-08-30 22:07:10
Message-ID: 4B3EBD3B46D7D21194B30008C7B1C76505CA5A98@OLTEX134 (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
This is not a bug.  The problem was that I was not calling lo_unlink() after
consecutive lo_creat(), lo_close() calls.  I found this out by looking at
the file system containing the database and seeing hundreds of xinvOID and
xinxOID files.  After cleaning up these files I was able to run this program
without error.

> -----Original Message-----
> From:	Barnes, Sandy (Sandra) 
> Sent:	Tuesday, August 29, 2000 11:06 AM
> To:	'pgsql-bugs(at)postgresql(dot)org'; 'Tom Lane'
> Cc:	Barnes, Sandy (Sandra)
> Subject:	[BUG] calling lo_creat()   
> Per Tom's suggestion I am submitting my problem to BUGS email list.  Our
> project would like to use PostgreSQL in an embedded application that is
> highly reliant on creating, storing and accessing large objects.  I had
> hoped that when lo_creat() returned a zero, I could test for this and call
> lo_creat() until a valid oid is returned.  The Database log error tells me
> to recreate an index.  Why ?  How?... not sure what to do from here.
> Thank you in advance for the time you may spend on this !
> Platform: PostgreSQL 7.0.2 on RedHat6.2  Linux
> Test:  Testing the creation of large objects.  I was putting the large
> objects into a database table but this 
>        test program recreates the error for me without having to do that. 
> Program Error: Can't create large objectoid [55592]  21
> Database Log Error: FATAL 1: my bits moved right off the end of the world!
> 					Recreate index
> pg_attribute_relid_attnum_index
>  << File: testOid2.doc >> 
>  << File: output.doc >> 
> Sandy Barnes
> email    sandy(dot)barnes(at)honeywell(dot)com

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2000-08-31 00:08:42
Subject: misleading (or perhaps confusing) error messages
Previous:From: pgsql-bugsDate: 2000-08-30 21:13:39
Subject: Page 13 of tutorial has a typo I believe

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