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

           Summary: buggy code in function moveSet_int (slony1_funcs.sql)
           Product: Slony-I
           Version: devel
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: high
         Component: stored procedures
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: cyril.scetbon at free.fr
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


there is a buggy code in this procedure in the condition "if v_last_sync > 0"
you're trying to make a bad insert request (too much values compare to the
number of columns) as you can see :

  2105                  if v_last_sync > 0 then
  2106                          insert into @NAMESPACE at .sl_setsync
  2107                                          (ssy_setid, ssy_origin,
ssy_seqno,
  2108                                          ssy_snapshot, ssy_action_list)
  2109                                          select p_set_id, p_new_origin,
v_last_sync,
  2110                                          ev_snapshot, NULL
  2111                                          from @NAMESPACE at .sl_event
  2112                                          where ev_origin = p_new_origin
  2113                                                  and ev_seqno =
v_last_sync;
  2114                  else
  2115                          insert into @NAMESPACE at .sl_setsync
  2116                                          (ssy_setid, ssy_origin,
ssy_seqno,
  2117                                          ssy_snapshot, ssy_action_list)
  2118  ------> ERROR HERE                      values (p_set_id, p_new_origin,
'0',
  2119                                          '0', '0', '0:0:', NULL);
  2120                  end if;


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