Thread: Re: [INTERFACES] libpq, large Objects

Re: [INTERFACES] libpq, large Objects

From
"John Huttley"
Date:
-----Original Message-----
From: Tom Lane <tgl@sss.pgh.pa.us>
To: John Huttley <john@mwk.co.nz>
Cc: PGSQL-Interfaces <pgsql-interfaces@postgreSQL.org>
Date: Monday, 21 June 1999 11:30
Subject: Re: [INTERFACES] libpq, large Objects


>"John Huttley" <john@mwk.co.nz> writes:
>> How do you destroy a large_object?
>
>lo_unlink(oid_of_large_object)


Thanks


>> AFAIK, the only way to do it is to put its OID into a tuple in a table
and
>> then delete that tuple.
>
>AFAIK, that will *not* remove the LO, just the referencing tuple ...
>




Thats pretty weird. Would Vaccum detect and remove orphaned OID's?

Regards