[rt-devel] RT 2.0.14-pre1

Florian Weimer 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
> varchars?

I'm not aware of any tradeoffs, and the documentation suggests there
aren't any.

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 mailing list