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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
