Re: limit of data type character varying

2020-11-25 Thread David G. Johnston
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

limit of data type character varying

2020-11-25 Thread Mark Phillips
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.