[rt-devel] [BUG] Email bounces when subject > 200 bytes
fw at deneb.enyo.de
Wed Feb 18 14:47:05 EST 2004
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
More information about the Rt-devel