Issue 971672: postgresql backend cannot handle messages > 256 - Roundup tracker

classification

Title:	postgresql backend cannot handle messages > 256
Type:		Severity:	normal
Components:	Database	Versions:

process

Status:	closed	Resolution:	fixed
Dependencies		Superseder:
Assigned To:	richard	Nosy List:	richard
Priority:	normal	Keywords:

Created on 2004-06-12 12:12 by anonymous, last changed 2004-06-13 00:02 by richard.

Messages
msg1304	Author: [hidden] (anonymous)	Date: 2004-06-12 12:12
looks like every character column in the DB is created as varying(255) which isn't a good idea for messages, as their length often exceeds 255 chars. ProgrammingError: ERROR: value too long for type character varying(255) insert into _msg (_activity,_actor,_author,_creation,_creator,_date,_inreplyto,_messageid,_summary,id) values ('2004-06-12 11:31:55.451',9,9,'2004-06-12 11:31:55.451',9,'2004-06-12 11:31:55.338',NULL,NULL,'XXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ... ',772)
msg1305	Author: [hidden] (richard)	Date: 2004-06-13 00:02
Logged In: YES user_id=6405 This was fixed in 0.7.4

History
Date	User	Action	Args
2004-06-12 12:12:38	anonymous	create