BUG #4043: Unrecognized node type: using plpgsql
| От | Reinier Suurenbroek |
|---|---|
| Тема | BUG #4043: Unrecognized node type: using plpgsql |
| Дата | |
| Msg-id | 200803181638.m2IGcgKG011137@wwwmaster.postgresql.org обсуждение |
| Ответы |
Re: BUG #4043: Unrecognized node type: using plpgsql
|
| Список | 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 по дате отправления: