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".
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 |