"Marko Kreen" <[EMAIL PROTECTED]> writes: > On 2/6/07, Marko Kreen <[EMAIL PROTECTED]> wrote: >> STRICT IMMUTABLE fixed the crash for me so seems it was bug >> in the module. Although it did not happen in 8.2.1 so seems >> some change in 8.2.2 made it trigger.
> Trigger was following patch: > http://archives.postgresql.org/pgsql-committers/2007-02/msg00016.php > as function test.break_guid() assigns NULLs to gplus_ret. So in fact the problem was that the input function was not declared STRICT and yet failed to handle nulls... which means it was broken as of 8.2.0, the OP just hadn't tried to throw a null at it except in the context of plpgsql ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
