On Wed, Nov 25, 2020 at 1:43 PM Mark Phillips
wrote:
> The actual maximum length supported by postgresql 12 is 10,485,760. We dug
> into the postgres code and found a limit in the config with a comment
> dating it to the pg 8.5 era. Being the simple folk that we are, we changed
> the setting to
Ran into a problem with SymmetricDS when attempting to sync two postgres 12
databases.
The problem occurs when Symmetric builds the XML for a table that has the
character varying datatype with an undefined length. SymmetricDS creates in the
xml character field that is 2,147,483,647 length.