bugzilla-daemon at main.slony.info bugzilla-daemon at main.slony.info
Sun Feb 23 20:28:57 PST 2014
http://www.slony.info/bugzilla/show_bug.cgi?id=331

           Summary: 2.2 replication between 9.3 and 8.4 fails on bytea
                    columns
           Product: Slony-I
           Version: devel
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: low
         Component: slon
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: jeff at pgexperts.com
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


Looks like the logtrigger stores the bytea columns in 'hex' format in sl_log_*
and then the slon chokes on that when replaying against 8.4

error at end of COPY IN: ERROR:  invalid input syntax for type bytea

maybe throw in a check for 8.4 and use encode/decode?

Why would you want to replicate from 9.3 to 8.4?  Just in case you need to
fallback after the migration.

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