Thu Dec 3 14:02:04 PST 2009
- Previous message: [Slony1-general] PGRES_FATAL_ERROR ERROR: cannot change return type of existing function
- Next message: [Slony1-general] PGRES_FATAL_ERROR ERROR: cannot change return type of existing function
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
I found an error. the "drop" statement generated by the drop_if_exists function does not qualify the function name's schema. I restored my schema from a dump with slony 2.1.16, then added the drop_if_exists() function to it from the 1.2.18 file (manually replacing @NAMESPACE@ with _rt which is my namespace). Specifically: vktest=# select _rt.drop_if_exists ('ddlscript_complete', 'int4, text, int4');ERROR: function ddlscript_complete(integer, text, integer) does not exist CONTEXT: SQL statement "drop function ddlscript_complete(int4, text, int4);" PL/pgSQL function "drop_if_exists" line 7 at EXECUTE statement changing the drop to be: ... v_drop := ''drop function @NAMESPACE at .'' || p_function ... allows it to succeed: vktest=# select _rt.drop_if_exists ('ddlscript_complete', 'int4, text, int4'); drop_if_exists ---------------- 1
- Previous message: [Slony1-general] PGRES_FATAL_ERROR ERROR: cannot change return type of existing function
- Next message: [Slony1-general] PGRES_FATAL_ERROR ERROR: cannot change return type of existing function
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list