http://www.slony.info/bugzilla/show_bug.cgi?id=332

           Summary: Exclude unreplicable objects from replication
           Product: Slony-I
           Version: devel
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: enhancement
          Priority: low
         Component: stored procedures
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: cbbrowne at ca.afilias.info
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


A user reported that they made the mistake of using over-broad wildcards to
specify the sequences to replicate.

This led to the sequence that captures the node ID being replicated, which then
led to subscriber nodes all deciding they were the origin node.  This is the "I
am Spartacus!" bug. 
http://en.wikipedia.org/wiki/Spartacus_%28film%29#.22I.27m_Spartacus.21.22

We should add some error checking to the functions that control adding tables
and sequences to replication so that they will decline to add dangerous objects
to replication, specifically:

a) Slony sequences, which may be recognized by having namespace ~ '^_.*' and
name like 'sl_%'

b) Slony tables, which may be recognized by having namespace ~ '^_.*' and name
like 'sl_%'

c) Objects in schemas pg_catalog and information_schema

-- 
Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
You are the assignee for the bug.