[rt-devel] RT 2.0.14-pre1

Jesse Vincent jesse at bestpractical.com
Mon Jul 1 13:32:12 EDT 2002


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

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


Hm. are there no other tradeoffs, or are texts now just superlong varchars?

> 
> -- 
> 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
> 
> _______________________________________________
> rt-devel mailing list
> rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel
> 

-- 
http://www.bestpractical.com/products/rt  -- Trouble Ticketing. Free.




More information about the Rt-devel mailing list