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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
