[rt-devel] RT 2.0.14-pre1
Weimer at CERT.Uni-Stuttgart.DE
Mon Jul 1 13:45:45 EDT 2002
Jesse Vincent <jesse at bestpractical.com> writes:
>> 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.
> Urk. they changed that behavior?
Yes, I think so:
>> 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.
> Hm. are there no other tradeoffs, or are texts now just superlong
I'm not aware of any tradeoffs, and the documentation suggests there
But I'm going to ask on the PostgeSQL mailing lists to be sure.
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