bugzilla-daemon at main.slony.info bugzilla-daemon at main.slony.info
Wed Aug 31 12:42:22 PDT 2011
http://www.slony.info/bugzilla/show_bug.cgi?id=237

           Summary: drop set does not remove truncate triggers
           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: ssinger at ca.afilias.info
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


14: PGRES_FATAL_ERROR lock table "_disorder_replica".sl_config_lock;select
"_disorder_replica".setAddTable(4, 9, 'disorder.do_config', 'do_config_pkey',
'disorder.do_config');  - ERROR:  trigger "_disorder_replica_truncatetrigger"
for relation "do_config" already exists


The above error happens if you try to add a table to replication that was
previously part of a replication set that was dropped.

alterTableDropTriggers does not remove the truncate trigger from the table.

This bug is new in 2.1.0 and is present in 2.1.0 rc1

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