Re: [INTERFACES] libpq, large Objects

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [INTERFACES] libpq, large Objects
Дата
Msg-id 13175.929921283@sss.pgh.pa.us
обсуждение исходный текст
Ответ на libpq, large Objects  ("John Huttley" <john@mwk.co.nz>)
Список 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 по дате отправления:

Предыдущее
От: Christian Borowski
Дата:
Сообщение: problems with Postgres 6.4.2 and Applix 4.4.1
Следующее
От: spertus@ella.mills.edu
Дата:
Сообщение: Re: [INTERFACES] NullPointerException in blobtest (JDBC)