[ Please trim quotes appropriately when replying. Nobody wants to read the whole history of the thread to get to your comment. ]
Japin Li <japi...@hotmail.com> writes: > Oh! I didn't consider this situation. Since the max size of varchar cannot > exceed 10485760, however, I cannot find this in documentation [1]. Is there > something I missed? Should we mention this in the documentation? > [1] https://www.postgresql.org/docs/devel/datatype-character.html I dunno, that section doesn't really get into implementation limits. For comparison, it doesn't bring up the point that string values are constrained to 1GB; that's dealt with elsewhere. Since the limit on typmod is substantially more than that, I'm not sure there's much point in mentioning it specifically. Maybe there's a case for mentioning the 1GB limit here, though. regards, tom lane
