Deleting records with text fields

Поиск
Список
Период
Сортировка
От Kovács Péter
Тема Deleting records with text fields
Дата
Msg-id 8A2DDD7ED7876A4698F6FF204F62CBFC014E5779@budg112a.sysdata.siemens.hu
обсуждение исходный текст
Ответы Re: Deleting records with text fields
Список pgsql-jdbc
Hi,

I read in this new group a short thread about deleting large objects through
jdbc. From this thread I learned that if I delete a record with a large
object field in it (I am using here a simplified formulation), the large
object will not be deleted automatically with the record, but has to be
deleted in a seperate operation.

Instinctively, I would think that this kind of design was applied to the
"text" type, since it also can accomodate data of practically (from my
perspective) unlimited size. So should I do some extra work, when I want to
get rid of a record containing a text field, or will deleting only the
record also delete the text object represented by the text field in the
record? Is the design for the "text" type different from large objects?

Thank you

Peter

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

Предыдущее
От: "Thomas O'Dowd"
Дата:
Сообщение: Re: MD5-based passwords
Следующее
От: Antonio Fiol Bonnín
Дата:
Сообщение: Relation modified while in use