Re: [INTERFACES] libpq, large Objects

From: "John Huttley" <john(at)mwk(dot)co(dot)nz>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "PGSQL-Interfaces" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: [INTERFACES] libpq, large Objects
Date: 1999-06-22 04:42:52
Message-ID: 005601bebc69$b235a280$1401a8c0@Mr_Creosote.MWK.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces


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

>"John Huttley" <john(at)mwk(dot)co(dot)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

Browse pgsql-interfaces by date

  From Date Subject
Next Message John Huttley 1999-06-22 04:45:49 Re: [INTERFACES] libpq, large Objects
Previous Message selkovjr 1999-06-22 00:46:39 Re: [INTERFACES] esql\c documentation