[rt-devel] RT 2.0.14-pre1
Weimer at CERT.Uni-Stuttgart.DE
Mon Jul 1 11:33:00 EDT 2002
Florian Weimer <Weimer at CERT.Uni-Stuttgart.DE> writes:
>> Would that be more accurately, when the subject line is longer than the
>> SQL field, RT borks ?
> I think the limit is 255 characters, and we don't hit this one.
Actually, the limit is 100 characters, for transactions.data. Older
PostgreSQL versions silently truncated overlong values for VARCHAR
columns, but newer ones (since 7.2 or so) don't.
Looks like I have to restructure the whole database. :-/
Jesse, maybe it's a good idea to use TEXT fields instead of VARCHAR
fields when creating new PostgreSQL databases? According to the
documentation, there is no performance difference.
Florian Weimer Weimer at CERT.Uni-Stuttgart.DE
University of Stuttgart http://CERT.Uni-Stuttgart.DE/people/fw/
RUS-CERT fax +49-711-685-5898
More information about the Rt-devel