Re: [INTERFACES] libpq, large Objects

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>
Subject: Re: [INTERFACES] libpq, large Objects
Date: 1999-06-20 23:28:03
Message-ID: 13175.929921283@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Browse pgsql-interfaces by date

  From Date Subject
Next Message spertus 1999-06-20 23:52:33 Re: [INTERFACES] NullPointerException in blobtest (JDBC)
Previous Message Christian Borowski 1999-06-20 23:26:48 problems with Postgres 6.4.2 and Applix 4.4.1