The following bug has been logged online:
Bug reference: 4043
Logged by: Reinier Suurenbroek
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.0
Operating system: SuSE Linux Enterprise Server 10sp1
Description: Unrecognized node type: using plpgsql
Details:
Changing owner of database or schema results in errormessage.
------------- Script -------------
CREATE OR REPLACE FUNCTION trecht() RETURNS integer
AS $$
BEGIN
EXECUTE 'ALTER DATABASE db1 OWNER TO reino' ;
EXECUTE 'ALTER SCHEMA schm1 OWNER TO reino' ;
END;
$$
LANGUAGE plpgsql;
------------- Script -------------
------------- Output -------------
select trecht();
ERROR: unrecognized node type: 1835557747
CONTEXT: SQL statement "ALTER SCHEMA schm1 OWNER TO reino"
PL/pgSQL function "trecht" line 2 at EXECUTE statement
reino=# \i t.sql
CREATE FUNCTION
reino=# select trecht();
ERROR: unrecognized node type: 3236452
CONTEXT: SQL statement "ALTER DATABASE db1 OWNER TO reino"
PL/pgSQL function "trecht" line 2 at EXECUTE statement
------------- Output -------------
I've no problems running these command "by hand".
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
