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

From Tom Lane
Subject Re: [INTERFACES] libpq, large Objects
Date
Msg-id 13175.929921283@sss.pgh.pa.us
Whole thread Raw
In response to libpq, large Objects  ("John Huttley" <john@mwk.co.nz>)
List pgsql-interfaces
"John Huttley" <john@mwk.co.nz> writes:
> How do you destroy a large_object?

lo_unlink(oid_of_large_object)

> 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 ...

> How do you truncate a large_object?

I don't believe there's any way to do that.  It's an oversight, for
sure.
        regards, tom lane


pgsql-interfaces by date:

Previous
From: Christian Borowski
Date:
Subject: problems with Postgres 6.4.2 and Applix 4.4.1
Next
From: spertus@ella.mills.edu
Date:
Subject: Re: [INTERFACES] NullPointerException in blobtest (JDBC)