Re: [INTERFACES] libpq, large Objects - Mailing list pgsql-interfaces

From John Huttley
Subject Re: [INTERFACES] libpq, large Objects
Date
Msg-id 005601bebc69$b235a280$1401a8c0@Mr_Creosote.MWK.co.nz
Whole thread Raw
List pgsql-interfaces
-----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





pgsql-interfaces by date:

Previous
From: selkovjr@mcs.anl.gov
Date:
Subject: Re: [INTERFACES] esql\c documentation
Next
From: "John Huttley"
Date:
Subject: Re: [INTERFACES] libpq, large Objects