Forum OpenACS Development: Re: db_string fails for large text columns

Collapse
Posted by Dave Bauer on
This is a call to a plpgsql function. The error message tells you the problem is in the SQL statement update acknowledgements.... There are two problems that could occur 1) the column you are updating is not long enough. 2) The plpgsql function argument is not long enough. If you changed the column in the table but did not change the function definition, it would try to put the value into the function argument which would be too small.

ERROR: value too long for type character varying(2000)
CONTEXT: SQL statement "update acknowledgments set shortname = $1 , title = $2 , description = $3 , global_p = $4 \
, ack_mode = $5 , ack_phrase = $6 , group_id = $7 , due_date = $8 where ack_id = $9 "
PL/pgSQL function "acknowledgment__edit" line 13 at SQL statement

SQL: select acknowledgment__edit('1','terms_of_use','Terms of Use','
...[28K characters]...','f','checkbox',NULL,'-2',NULL)