hi,
I an using postgresql-7.1beta4 and am trying to use the large text fields. 
I have heard of TOAST. There is little documentation. 
  I found one section about creating a data type,
then creating two functions to convert the data types.
Is this how TOAST is implemented?
Am I on the right track?.   If so,  what do
the conversion functions look like. I am using plpgsql.
Thanks, Pam


Fri, 9 Mar 2001 13:54:40 +1100 
Pam Withnall <Pamw@zoom.com.au>
TOAST
On Fri, Mar 09, 2001 at 01:54:40PM +1100, Pam Withnall wrote:
> hi,
> I an using postgresql-7.1beta4 and am trying to use the large text fields. 
> I have heard of TOAST. There is little documentation. 
>   I found one section about creating a data type,
> then creating two functions to convert the data types.
> Is this how TOAST is implemented?
> Am I on the right track?.   If so,  what do
> the conversion functions look like. I am using plpgsql.
> Thanks, Pam

TOAST works transparently for the user. It just means that the old
pre-7.1 8k (actually 32) row length limit is obsolete. In order to use
large text fields all you need to do is install 7.1 (which you already
have, as you say). No function creation etc. is required.

Regards, Frank

Tue, 13 Mar 2001 09:11:15 +0100
Frank Joerdens <frank@joerdens.de>
Re: TOAST