Re: large object seek/write bug

Ian Grant <ian.grant@cl.cam.ac.uk>

From: Ian Grant <Ian.Grant@cl.cam.ac.uk>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Ian.Grant@cl.cam.ac.uk, pgsql-bugs@hub.org
Date: 2000-06-15T09:45:35Z
Lists: pgsql-bugs
> Thank you for the carefully developed test case.  The bug is actually
> in the backend, not in libpq: ... snip ...
>
> I believe the attached patch fixes these problems, but I haven't been
> able to wring it out very thoroughly because I don't have applications
> that do random seeks and writes in large objects.  If you could bang
> on it a little more and report back, that'd be great.

Hi Tom.  Thanks for the response and the quick fix.  I'll write some more test cases now.  I just thought that whilst this part of the backend is still fresh in your mind you might consider implementing lo_truncate (the lo_ analog of the unix truncate system call.)  At present there is no way to reduce the size of a large object except by copying to a new one (and then we still can't delete the old one, or can we do that now?)

Cheers
Ian
-- 
Ian Grant, Computer Lab., New Museums Site, Pembroke Street, Cambridge
Phone: +44 1223 334420          Personal e-mail: iang at pobox dot com