Hello,

On the GBorg bugtracker I have reported two problems with the
slony1_dump.sh script:
http://gborg.postgresql.org/project/slony1/bugs/bugupdate.php?1458
http://gborg.postgresql.org/project/slony1/bugs/bugupdate.php?1459

The attached patches fix the problems.

Greets,
        Jacek
-------------- next part --------------
diff -dur -x '*~' slony1-1.1.2.orig/tools/slony1_dump.sh slony1-1.1.2/tools/slony1_dump.sh
--- slony1-1.1.2.orig/tools/slony1_dump.sh	2005-09-28 03:18:56.000000000 +0200
+++ slony1-1.1.2/tools/slony1_dump.sh	2005-11-03 10:00:46.000000000 +0100
@@ -177,7 +177,7 @@
 # ----
 echo "select 'copy $clname.sl_sequence_offline from stdin;';"
 echo "select seq_id::text || '	' || seq_relname  || '	' || seq_nspname from $clname.sl_sequence;"
-echo "select '\\\\.';"
+printf "select '\\\\\\\\.';"
 
 for seq in $sequences ; do
 	eval seqname=\$seqname_$seq
@@ -203,7 +203,7 @@
 
 	echo "copy $tabname to stdout;"
 
-	echo "select '\\\\.';"
+	printf "select '\\\\\\\\.';"
 done
 
 # ----
-------------- next part --------------
diff -dur -x '*~' slony1-1.1.2.orig/tools/slony1_dump.sh slony1-1.1.2/tools/slony1_dump.sh
--- slony1-1.1.2.orig/tools/slony1_dump.sh	2005-11-04 13:05:15.000000000 +0100
+++ slony1-1.1.2/tools/slony1_dump.sh	2005-11-04 13:06:43.000000000 +0100
@@ -130,7 +130,7 @@
 -- ---------------------------------------------------------------------------------------
 -- FUNCTION setsyncTracking_offline (seq_id, seq_origin, ev_seqno, last_value, sync_time)
 -- ---------------------------------------------------------------------------------------
-create or replace function $clname.setsyncTracking_offline(int4, int8, int8) returns int8
+create or replace function $clname.setsyncTracking_offline(int4, int8, int8, timestamp) returns int8
 as '
 declare
 	p_set_id	alias for \$1;