Marek Becka marek.becka at superhosting.cz
Wed Jun 6 04:55:14 PDT 2018
Hello,


since Slony-I 2.1 a POSIX regular expresions can be used for adding 
tables and sequences to a replication set. I have tried to add all 
tables using Slony 2.2.5 documentation example of command SET ADD TABLE:

SET ADD TABLE (SET ID=1, TABLES='public\\.tracker*');

In this case backslash must be escaped to get intended regular expression.


Regular expresions used with SET ADD SEQUENCE doesn't works correctly 
with doubled backslash. To select all sequences from public schema plain 
regular expression must be used:

SET ADD SEQUENCE (SET ID=1, SEQUENCES='public\.*');


Shouldn't be both command handled consistently?




More information about the Slony1-general mailing list