Email::Store::Attachment - my losing battle

[Toby Corkindale]

On Wed, Nov 29, 2006 at 03:37:17PM +0000, Christopher Jones wrote:
> I would guess don't use PostgreSQL to store binary objects, use an 
> engine that supports a proper BLOB field, like MySQL.

But.. PostgreSQL does support blobs??
(Says someone who has metric tonne of video, jpeg, etc blobs in their Pg db)

> 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.
> >

-- 
Turning and turning in the widening gyre/The falcon cannot hear the falconer;
Things fall apart, the centre cannot hold/Mere anarchy is loosed upon the world
(gpg --keyserver www.co.uk.pgp.net --recv-key B1CCF88E)