Kristis Makris ([EMAIL PROTECTED]) reports a bug with a severity of 4
The lower the number the more severe it is.
Short Description
In plpgsql, returning "text" instead of "setof text" puts backend in infinite loop
Long Description
This was run against postgres 7.1.3. While experimenting with "setof" in writing a
plpgsql function I came across a case where if text is returned in place of setof
text, the backend never came up with a reply. top reported the postmaster running at
%99.9 until I Ctrl-C'ed.
Sure, text should not be returned in place of setof text, but still...
=# select AAA(now());
Cancel request sent
ERROR: Query was cancelled.
=#
Sample Code
create function AAA(date) returns setof text as '
declare
-- _date alias for $1;
_reads text;
begin
return _reads;
end;
' language 'plpgsql';
SELECT AAA(now());
No file was uploaded with this report
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
