Re: What happens if you delete a row containing a BLOB?

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: What happens if you delete a row containing a BLOB?
Дата
Msg-id GNELIHDDFBOCMGBFGEFOAENCCAAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответ на What happens if you delete a row containing a BLOB?  (Terrence Brannon <metaperl@mac.com>)
Список pgsql-sql
Дерево обсуждения 
> If you delete a row with a BLOB, does it automatically lo_unlink
> the blob?

No, I believe it does not - you need to run an 'lo_delete' command
separately.  In Postgres 7.1+ though, I think it's easier to just use the
'bytea' binary large string type.  It's there in 7.1, but 7.2 has introduced
many new operators for it.

Chris

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

Предыдущее
От: marc@oscar.eng.cv.net (Marc Spitzer)
Дата:
Сообщение: Re: persistent connections, AOLserver (Was: maybe Offtopic :
Следующее
От: MindTerm
Дата:
Сообщение: Re: performance tuning in large function / transaction