Maximum size for char or varchar with limit - Mailing list pgsql-general

Hello,

Does anyone know what the maximum length is for char or varchar
columns with limit.
I saw some answers to this same question referring to section 8.3 of
the docs, but I don't see the actual numbers there.

I know you can go to 1GB if you don't specify the limit, but I would
like to know what the max limit is you can use.

It seems to be 10485760 in my install.
Is this fixed in PostgreSQL or does it depend on some configuration setting?
Does it depend on the version (I am using 8.4)?


Here is my test-sql:

create table test (x varchar(100000000))

Error: ERROR: length for type varchar cannot exceed 10485760
SQLState:  22023
ErrorCode: 0

Thanks in advance,

Rob