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

Kouprie, Robbert R.Kouprie at DTO.TUDelft.NL
Wed Feb 18 08:49:54 EST 2004

Hi Florian,

Thanks for the explanation.
Someone from the RT dev team might want to fix the shipped Postgres database

-- Robbert

> -----Original Message-----
> From: Florian Weimer [mailto:fw at deneb.enyo.de]
> Sent: Tuesday, February 17, 2004 11:02 PM
> To: Kouprie, Robbert
> Cc: 'rt-devel at lists.bestpractical.com'
> Subject: Re: [rt-devel] [BUG] Email bounces when subject > 200 bytes
> Kouprie, Robbert wrote:
> > I traced it down to the subject field of the incoming 
> e-mail being > 200
> > bytes, and therefore Postgres erroring out.
> This is a known problem and affects other fields as well.  You should
> fix it by changing the type of table columns (change all occurences of
> type VARCHAR to type TEXT).
> On PostgreSQL, there is no performance difference between VARCHAR and
> TEXT; operations on both types are implemented by the same code, and
> PostgreSQL can't exploit fixed-length records (unlike other 
> databases).

More information about the Rt-devel mailing list