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

Florian Weimer fw at deneb.enyo.de
Tue Feb 17 17:01:47 EST 2004


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