> prova=> create table a1(a varchar(99999));
> ERROR: length for type 'varchar' cannot exceed 8064
> prova=> create table a1(a varchar(8064));
> CREATE
thanks, for this quick answer!
i did the test by myself and found out, that on the my system (freebsd
3.2) where i do actualy my tests, varchar is limited to 4096. this creates
the problem of plattfrom dependence.
what length has the text field?
-> i tried a insert-command with some 10000 signs for one text-field
-> i got a "PQsendQuery() -- query is too long. Maximum length is 8191"
hmpf. so maximum length may not exceed 8191 signs in any case. this causes
textfields to be reduced to a variable length, which depends on the amount
of your table-fields; just think of these two cases:
a table with 50 fields and a realy big textfield
a table with 2 fields where one is a realy big textfield
in the first case the textfield has to be smaller, since i can't exceed
the maximum query length of 8191 signs.....
now what? :)
thanks,
guenther