Re: Deleting records with text fields

Поиск
Список
Период
Сортировка
От Rene Pijlman
Тема Re: Deleting records with text fields
Дата
Msg-id e3gjut05clifi395gfnp5a0b3vedbc5gqg@4ax.com
обсуждение исходный текст
Ответ на Deleting records with text fields  (Kovács Péter <peter.kovacs@sysdata.siemens.hu>)
Список pgsql-jdbc
On Wed, 7 Nov 2001 08:56:59 +0100 , you wrote:
>So should I do some extra work, when I want to
>get rid of a record containing a text field,

No, that's not necessary.

>or will deleting only the record also delete the text object
>represented by the text field in the record?

Yes. In fact, there is no text object, just a text field which
happens to be very large.

>Is the design for the "text" type different from large objects?

Yes. This was implemented in 7.1:
http://postgresql.lerner.co.il/projects/devel-toast.html

Regards,
René Pijlman <rene@lab.applinet.nl>

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

Предыдущее
От: Rene Pijlman
Дата:
Сообщение: Re: Funny timezone shift causes failure in test suite
Следующее
От: tomcat@meinsenf.at
Дата:
Сообщение: missing quote_string - function