On 2/6/07, Jonathan Gray <[EMAIL PROTECTED]> wrote:
Following an upgrade to 8.2.2, many of my plpgsql functions started to cause
server process crashes.
I make use of a custom data-type "uniqueidentifier", available here:
http://gborg.postgresql.org/project/uniqueidentifier
ftp://gborg.postgresql.org/pub/uniqueidentifier/stable/uniqueidentifier-0.2.
tar.gz
This type has given me the same kind of process crash once before, but that
was related to NULL values in a foreign-key referenced field (unresolved to
this day, but behavior is allowed for all builtin types).
Indeed, the code can crash on NULL values as the NULL checks
are missing or wrong in the functions. Actually all the various
functions except newid() should be declared STRICT IMMUTABLE
thus immidiately avoiding problems with NULLs.
Could you reproduce the crash with this change? I'll try
to play with this myself too.
--
marko
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
