string too long in initial_insert.sql

Hi, PostgreSQL claims during loading initial_insert.sql that the following insert statemant contains a too long string in the 'name' field: INSERT INTO charset (name, charset, comment, valid_id, create_by, create_time, change_by, change_time) VALUES ('Cyrillic Charset (Windows-1251)', 'Windows-1251', 'Windows-1251 - cp1251', 1, 1, current_timestamp, 1, current_timestamp); You might want to define a larger string field in the schema. Ingo -- -----BEGIN GEEK CODE BLOCK----- Version: 3.1 GCM/IT/B/O d+(-) s+:++ a C++ UL++++$ P++$ L+++@ E- W+++@ N+ o? K? w-- O M++@ V PS+ PE++ Y+ PGP++ t++ 5 X R tv+ b+@ DI+@ D--- G+ e? h-- r+++@ y? ------END GEEK CODE BLOCK------

Hi Ingo, On Fri, Nov 29, 2002 at 10:11:33PM +0100, Ingo Ciechowski wrote:
PostgreSQL claims during loading initial_insert.sql that the following insert statemant contains a too long string in the 'name' field:
INSERT INTO charset (name, charset, comment, valid_id, create_by, create_time, change_by, change_time) VALUES ('Cyrillic Charset (Windows-1251)', 'Windows-1251', 'Windows-1251 - cp1251', 1, 1, current_timestamp, 1, current_timestamp);
You might want to define a larger string field in the schema.
Ja, thanks for the note. :) I updated scripts/DBUpdate.postgresql.sql and the install/database/OpenTRS-schema.postgresql.sql.
Ingo
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "Security is a process, not a product." - Bruce Schneider
participants (2)
-
Ingo Ciechowski
-
Martin Edenhofer