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
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
# ----
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;
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
