Re: [GENERAL] Large objects

Peter Mount <pgsqlgen@retep.org.uk>

From: Peter Mount <pgsqlgen@retep.org.uk>
To: Kurt Seel <kseel@utcorp.com>
Cc: pgsql-general@postgresql.org
Date: 1998-06-28T08:32:47Z
Lists: pgsql-general
On Fri, 26 Jun 1998, Kurt Seel wrote:

> I am having trouble with writing to large objects.

>  I am not using lseek, as I have heard it is broken.

It shouldn't be broken. When I implemented them for JDBC, I used lseek to
get the object's size. It's worked fine (and that was just before 6.3 was
released).

> I simply read the whole thing into a buffer, edit it, and (attempt to) 
> write it back out.

Should work. I assume (as you say you are not using lseek) that you are
closing the object, then reopening it before writing?

>  I am doing this from TCL.

I don't know how TCL does this, but do you get any error messages?

-- 
Peter T Mount peter@retep.org.uk or petermount@earthling.net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk