[rt-devel] RT 2.0.14-pre1

[Florian Weimer]

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:

http://archives.postgresql.org/pgsql-sql/2001-05/msg00231.php

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