Re: another question concerning TOAST

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jessica Ditt <jessica(dot)ditt(at)web(dot)de>
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: another question concerning TOAST
Date: 2005-05-31 13:56:13
Message-ID: 11629.1117547773@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Jessica Ditt <jessica(dot)ditt(at)web(dot)de> writes:
> I don't know, where I made a mistake. I haven't been thinking of
> toasting / detoasting yet, although I now think, I have to.

If you are going to mark the datatype as toastable then you have to
be prepared to detoast values received by your functions.

Usually it's possible to hide this in your GETARG macro for the type.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Mya Johnson 2005-05-31 15:44:37 THEY FOUND NEW ANTIDOTE
Previous Message Keith Worthington 2005-05-31 13:01:02 Re: UPDATE with JOIN