BUG #4043: Unrecognized node type: using plpgsql

From: "Reinier Suurenbroek" <suurenbroek(at)nieuwland(dot)nl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4043: Unrecognized node type: using plpgsql
Date: 2008-03-18 16:38:42
Message-ID: 200803181638.m2IGcgKG011137@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4043
Logged by: Reinier Suurenbroek
Email address: suurenbroek(at)nieuwland(dot)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".

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2008-03-18 17:55:39 Re: BUG #3818: Cross compilation problems
Previous Message Chan, Keith (LESA IT) 2008-03-18 15:52:26 Re: BUG #4041: error in Application Stack Builder