Hi, I tried slony1_dump.sh; but it quick ended telling me I did misuse \\. So I tried with E'\\', and it seemed to work better. Here is the patch.
Regards, -- Stéphane SCHILDKNECHT Président de PostgreSQLFr 06 13 60 37 44 - 09 53 69 97 12 http://www.PostgreSQLFr.org
Index: slony1_dump.sh =================================================================== --- slony1_dump.sh (révision 854) +++ slony1_dump.sh (copie de travail) @@ -187,7 +187,7 @@ # ---- echo "select 'copy $clname.sl_sequence_offline from stdin;';" echo "select seq_id::text || ' ' || seq_relname || ' ' || seq_nspname from $clname.sl_sequence;" -printf "select '\\\\\\\\.';" +printf "select E'\\\\\\\\.';" for seq in $sequences ; do eval seqname=\$seqname_$seq @@ -215,7 +215,7 @@ fields=`psql -At -c "select $clname.copyfields($tab);" $dbname` echo "select 'copy $tabname $fields from stdin;';" echo "copy $tabname $fields to stdout;" - printf "select '\\\\\\\\.';" + printf "select E'\\\\\\\\.';" done # ----
_______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
