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

           Summary: insert error in function moveSet_int
           Product: Slony-I
           Version: devel
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: medium
         Component: stored procedures
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: aoyagi.kouhei at gmail.com
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


Postgresql8.4.1
Slony-I 2.0.3.RC3

I tried slonik_move_set.
----------------------
$/opt/slony1/bin/slonik_move_set set1 2 1 | grep -v "wait for" |
/opt/slony1/bin/slonik

<stdin>:4: Locking down set 1 on node 2
<stdin>:7: Locked down - moving it
<stdin>:8: PGRES_FATAL_ERROR select "_replication".moveSet(1, 1);  - ERROR: 
invalid input for txid_snapshot: "0:0:"
LINE 1: ...apshot, ssy_action_list) values ( $1 ,  $2 , '0', '0:0:', NU...
QUERY:  insert into "_replication".sl_setsync (ssy_setid, ssy_origin,
ssy_seqno, ssy_snapshot, ssy_action_list) values ( $1 ,  $2 , '0', '0:0:',
NULL)
CONTEXT:  PL/pgSQL function "moveset_int" line 97 at SQL
SQL "SELECT  "_replication".moveSet_int( $1 ,  $2 ,  $3 , 0)"
PL/pgSQL function "moveset" line 61 at PERFORM
----------------------

I tried simple sql.

--------------
select '0:0:'::txid_snapshot;
ERROR: invalid input for txid_snapshot: "0:0:"

select '1:1:'::txid_snapshot;
1:1:
--------------

I modified '0:0:' to '1:1:'.
Is it OK?


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