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

[Kouprie, Robbert]

Hi Florian,

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

Regards,
-- 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).
>