[rt-devel] [BUG] Email bounces when subject > 200 bytes

Kouprie, Robbert R.Kouprie at DTO.TUDelft.NL
Mon Mar 1 06:17:50 EST 2004


But all other schema's also use fixed varchar's. So truncation is definately
needed, I'd say.
So, to start somewhere, may I vote for inclusion of my original patch for
the case where Tickets.Subject overflows?

-- Robbert

-----Oorspronkelijk bericht-----
Van: Florian Weimer [mailto:fw at deneb.enyo.de]
Verzonden: woensdag 18 februari 2004 20:47
Aan: Jesse Vincent
CC: Kouprie, Robbert; 'rt-devel at lists.bestpractical.com'
Onderwerp: Re: [rt-devel] [BUG] Email bounces when subject > 200 bytes


Jesse Vincent wrote:

> On Wed, Feb 18, 2004 at 02:49:54PM +0100, Kouprie, Robbert wrote:
> > Hi Florian,
> > 
> > Thanks for the explanation.
> > Someone from the RT dev team might want to fix the shipped Postgres
database
> > schema?
> 
> I'm more tempted to go for a truncation solution, unless someone can
> explain to me what varchars without specified lengths do to index
> performance ;)

There's no index on tickets.subject. 8-)  But I see your point,
users.name is such a case.

Last time I looked at the PostgreSQL code, VARCHAR was implemented as
TEXT plus length checking.  Shall I recheck?

(Unfortunately, I don't have an RT3 instance sufficiently large for
benchmarking.)





More information about the Rt-devel mailing list