Re: another question concerning TOAST - Mailing list pgsql-novice

From Tom Lane
Subject Re: another question concerning TOAST
Date
Msg-id 11629.1117547773@sss.pgh.pa.us
Whole thread Raw
In response to another question concerning TOAST  (Jessica Ditt <jessica.ditt@web.de>)
List pgsql-novice
Jessica Ditt <jessica.ditt@web.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

pgsql-novice by date:

Previous
From: "Keith Worthington"
Date:
Subject: Re: UPDATE with JOIN
Next
From: Andreas
Date:
Subject: Logical problem with transactions and GUI-clients