>>>>> "Peter" == Peter Eisentraut <peter.eisentr...@2ndquadrant.com> writes:
Peter> The attached test fixes this issue by flattening the toast Peter> values before storing them into PL/pgSQL variables. It could use Peter> another check to see if there are other code paths that need Peter> similar adjustments, but I think it's the right idea in general. Uhh. What about: somevar := (select blah); or somevar := function_returning_toasted_val(blah); or call someproc(function_returning_toasted_val(blah)); or or or ... -- Andrew (irc:RhodiumToad)