bugzilla-daemon at main.slony.info bugzilla-daemon at main.slony.info
Wed Jul 3 13:47:40 PDT 2013
http://www.slony.info/bugzilla/show_bug.cgi?id=298

           Summary: Log shipping in 2.2.0 b4 does not ship EXCUTE SCRIPT
                    data
           Product: Slony-I
           Version: devel
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: enhancement
          Priority: low
         Component: slony_logshipper
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: ssinger at ca.afilias.info
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


When using a log shipping node in slony 2.2.0 b4 
If you do 
EXECUTE SCRIPT(event node=1,  SQL='alter table sname add column name text;');

The DDL shows up in the .sql files generated for the log shipping nodes but the
ALTER TABLE never executes on the log shipping targets.

The problem is that the apply trigger included in slony1_dump.sh does not have
a case for DDL scripts (type 'S')

-- 
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.


More information about the Slony1-bugs mailing list