Bug 331 - 2.2 replication between 9.3 and 8.4 fails on bytea columns
Summary: 2.2 replication between 9.3 and 8.4 fails on bytea columns
Status: NEW
Alias: None
Product: Slony-I
Classification: Unclassified
Component: slon (show other bugs)
Version: devel
Hardware: PC Linux
: low normal
Assignee: Slony Bugs List
URL:
Depends on:
Blocks:
 
Reported: 2014-02-23 20:28 UTC by Jeff Frost
Modified: 2014-02-23 20:28 UTC (History)
1 user (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.