Problem:

postgres at host~$ slonik_update_nodes --config=/etc/slony1/slon_tools.conf | slonik
<stdin>:4: Possible unsupported PostgreSQL version (80401) 8.4, defaulting to 8.3 support
<stdin>:4: loading of file /usr/share/slony1/slony1_funcs.sql: PGRES_FATAL_ERROR ERROR:  cannot change return type of existing function
HINT:  Use DROP FUNCTION first.
ERROR:  cannot change return type of existing function
HINT:  Use DROP FUNCTION first.

Patch:

--- src/backend/slony1_funcs.sql        2010-02-05 16:05:17.000000000 +0200
+++ src/backend/slony1_funcs.sql        2010-02-05 16:08:48.000000000 +0200
@@ -1478,6 +1478,8 @@
 --     Duplicate a nodes configuration under a different no_id in
 --     preparation for the node to be copied with standard DB tools.
 -- ----------------------------------------------------------------------
+drop function if exists @NAMESPACE at .cloneNodePrepare (int4, int4, text); -- Needed because function signature has changed!
+
 create or replace function @NAMESPACE at .cloneNodePrepare (int4, int4, text)
 returns bigint
 as $$

Cheers!

-- 
Atte Peltomäki
     atte.peltomaki at iki.fi <> http://kameli.org
"Your effort to remain what you are is what limits you"