BUG #4043: Unrecognized node type: using plpgsql - Mailing list pgsql-bugs

From Reinier Suurenbroek
Subject BUG #4043: Unrecognized node type: using plpgsql
Date
Msg-id 200803181638.m2IGcgKG011137@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4043: Unrecognized node type: using plpgsql
List pgsql-bugs
The following bug has been logged online:

Bug reference:      4043
Logged by:          Reinier Suurenbroek
Email address:      suurenbroek@nieuwland.nl
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".

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #3818: Cross compilation problems
Next
From: "Chan, Keith \(LESA IT\)"
Date:
Subject: Re: BUG #4041: error in Application Stack Builder