([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
PostgreSQL 7.1.1: Backend crash when calling plpgsql function
Long Description
Hi, while porting a 6.5 app to 7.1.1 i found a plpgsql function that crashes the
backend. Other functions work though. When i rewrite the function to be more sane, the
crash doesnt happen anymore. Still the backend shouldnt crash (and it didnt in 6.5
btw).
The whole db dump is about 28megs if anyone is interested.
In case it matters: the 7.1.1 was installed over a 7.0.3, so maybe there is some
plpgsql versioning conflict??
Thanks.
Sample Code
Crashing function:
CREATE FUNCTION "new_news" (varchar ) RETURNS int4 AS '
DECLARE
uid_p varchar;
BEGIN
Select l.uid into uid_p from nachrichten2 n2, luser l
WHERE l.uid = $1
AND l.uid = n2.uid
AND id > letzte_nachricht
group by l.uid;
IF uid_p ISNULL THEN
RETURN 0;
END IF;
RETURN 1;
END;
' LANGUAGE 'plpgsql';
Not crashing function:
CREATE FUNCTION "new_news" (varchar ) RETURNS int4 AS '
BEGIN
IF NOT EXISTS(
Select l.uid from nachrichten2 n2, luser l
WHERE l.uid = $1
AND l.uid = n2.uid
AND id > letzte_nachricht
) THEN
RETURN 0;
END IF;
RETURN 1;
END;
' LANGUAGE 'plpgsql';
No file was uploaded with this report
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
