Bug 331

Summary: 2.2 replication between 9.3 and 8.4 fails on bytea columns
Product: Slony-I Reporter: Jeff Frost <jeff>
Component: slonAssignee: Slony Bugs List <slony1-bugs>
Status: NEW ---    
Severity: normal CC: slony1-bugs
Priority: low    
Version: devel   
Hardware: PC   
OS: Linux   

Description Jeff Frost 2014-02-23 20:28:57 UTC
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.