BUG #1059: Second Call of a PGSQL-function fails

The following bug has been logged online:

Bug reference: 1059
Logged by: Wilhelm

Email address: wilhelm(dot)pakulla(at)gmx(dot)de

PostgreSQL version: 7.4

Operating system: Linux

Description: Second Call of a PGSQL-function fails

Details:

-- The Source:

-- Init Stuff
DROP FUNCTION plpgsql_call_handler () CASCADE;
CREATE FUNCTION plpgsql_call_handler () RETURNS LANGUAGE_HANDLER AS
'$libdir/plpgsql' LANGUAGE C;

CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql
HANDLER plpgsql_call_handler;

-- The function

CREATE FUNCTION f (INTEGER) RETURNS INTEGER
AS '
BEGIN
CREATE TABLE test ( x INTEGER );

-- Without this insert, everything works well...
INSERT INTO test VALUES (1);

DROP TABLE test CASCADE;

RETURN 0;
END;
' LANGUAGE 'plpgsql';

-- That works.
SELECT f(1);

-- Second Call fails.
SELECT f(1);

-- Thanks in advance, Wilhelm