Re: [GENERAL] How can i delete large objects from DB?

Поиск
Список
Период
Сортировка
От Dustin Sallings
Тема Re: [GENERAL] How can i delete large objects from DB?
Дата
Msg-id ML-3.5-SPY.902191645.3010.dustin@bleu.west.spy.net
обсуждение исходный текст
Ответ на How can i delete large objects from DB?  ("Sergei M. Suntsov" <serge@uic.nsu.ru>)
Ответы Re: [GENERAL] How can i delete large objects from DB?  (Peter T Mount <peter@retep.org.uk>)
Список pgsql-general
> Man page on large objects describes how to create one, from file wit
> lo_import, etc. But if i want delete row from the table which references
> large object should I delete large object also? How can it be done ?

    Well, BLOBs aren't actually stored *in* tables, but you could do a
trigger mechanism that says ``if someone deletes something from this table, do
this'' ...this being, ``lo_unlink(that blob)''

--
SA, software.net         My girlfriend asked me which one I like better.
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________


В списке pgsql-general по дате отправления:

Предыдущее
От: Dustin Sallings
Дата:
Сообщение: Re: [GENERAL] lo_import() problem
Следующее
От: The Hermit Hacker
Дата:
Сообщение: CD Distribution/Rates changed...