Email::Store::Attachment - my losing battle

[Christopher Jones]

I would guess don't use PostgreSQL to store binary objects, use an 
engine that supports a proper BLOB field, like MySQL.


Chris.


On 29 Nov 2006, at 14:35, Chisel Wright wrote:

> On Wed, Nov 29, 2006 at 02:15:51PM +0000, Richard Clamp wrote:
>> Postgres is trying to be clever because it knows it's interacting 
>> with a
>> text column.  That should probably be bytea for pg.
>> http://www.postgresql.org/docs/8.1/interactive/datatype.html
>
> alter table attachment drop column payload;
> alter table attachment add column payload bytea;
> # alter message id
>
> Same error. I'll have to dig deeper I think ... where's Matt Lawrence 
> when
> you need him? ;-)
>
> Chisel
> -- 
> Chisel Wright
> e: chisel at herlpacker.co.uk
> w: http://www.herlpacker.co.uk/
>
>   We never decided to postpone this issue.
>   We just agreed that we would deal with other issues first.
>