Re: Deleting records with text fields - Mailing list pgsql-jdbc

From Rene Pijlman
Subject Re: Deleting records with text fields
Date
Msg-id e3gjut05clifi395gfnp5a0b3vedbc5gqg@4ax.com
Whole thread Raw
In response to Deleting records with text fields  (Kovács Péter <peter.kovacs@sysdata.siemens.hu>)
List 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 by date:

Previous
From: Rene Pijlman
Date:
Subject: Re: Funny timezone shift causes failure in test suite
Next
From: tomcat@meinsenf.at
Date:
Subject: missing quote_string - function