| From: | Rene Pijlman <rene(at)lab(dot)applinet(dot)nl> |
|---|---|
| To: | Kovács Péter <peter(dot)kovacs(at)sysdata(dot)siemens(dot)hu> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Deleting records with text fields |
| Date: | 2001-11-07 23:25:21 |
| Message-ID: | e3gjut05clifi395gfnp5a0b3vedbc5gqg@4ax.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)lab(dot)applinet(dot)nl>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | tomcat | 2001-11-07 23:30:41 | missing quote_string - function |
| Previous Message | Rene Pijlman | 2001-11-07 22:01:13 | Re: Funny timezone shift causes failure in test suite |