Reinier Suurenbroek wrote: > ------------- 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
Yup, that's a known bug (#3940) fixed in 8.3.1. 2008-02-07 18:07 tgl * src/backend/: commands/alter.c (1.27), parser/gram.y (2.606): Some variants of ALTER OWNER tried to make the "object" field of the statement be a list of bare C strings, rather than String nodes, which is what they need to be for copyfuncs/equalfuncs to work. Fortunately these node types never go out to disk (if they did, we'd likely have noticed the problem sooner), so we can just fix it without creating a need for initdb. This bug has been there since 8.0, but 8.3 exposes it in a more common code path (Parse messages) than prior releases did. Per bug #3940 from Vladimir Kokovic. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs