Bug #847: plpgsql 'raise notice' > 4000 chars disconnects pgsql backend 7.2.1 - Mailing list pgsql-bugs

stephen dee (ala_frosty@yaho#nospam#o.com) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
plpgsql 'raise notice' > 4000 chars disconnects pgsql backend 7.2.1

Long Description
Try this:

It will cause you (et al) to get disconnected from the back end. Very cool if you want to annoy people.

SD

Sample Code
DROP FUNCTION sp_crashpg();

CREATE FUNCTION sp_crashpg() RETURNS varchar AS '
DECLARE
message varchar;
counts int4;
BEGIN
-- Do not crash yet:
message := repeat(''I am going to crash!'',200);
raise notice ''No crash: %'',message;
-- Okay, now bring it on HAL:
message := repeat(''I am going to crash!'',201);
raise notice ''Crash here: %'',message;

FOR counts IN 1..3 LOOP
    -- DO NOTHING
END LOOP;
RETURN ''I told you so'';
END;'
LANGUAGE 'plpgsql';

No file was uploaded with this report