Mon Feb 25 11:41:09 PST 2008
- Previous message: [Slony1-general] possible to replicate from text column in 8.1 into an xml column in 8.3?
- Next message: [Slony1-general] possible to replicate from text column in 8.1 into an xml column in 8.3?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> I'd expect that to work OK, but with one pretty big "foot gun" in > play, namely the fact that the XML type does validation. That > provides the risk that if you ever put invalid XML into the column in > the 8.1 database, the attempt to INSERT/UPDATE it on the 8.3 instance > will fail, and replication will fail (until/unless you delete the > offending tuples from sl_log_[12] by hand). That would be a nice way > to really muss up the cluster. That's great! I know every XML document is well-formed, and I have loaded all the data into an xml type column using pg_restore without errors. So I'll move forward with validating this approach (replicating using Slony). -- m@
- Previous message: [Slony1-general] possible to replicate from text column in 8.1 into an xml column in 8.3?
- Next message: [Slony1-general] possible to replicate from text column in 8.1 into an xml column in 8.3?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list