Email::Store::Attachment - my losing battle
tjc at wintrmute.net
Fri Dec 1 10:25:47 GMT 2006
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.
> >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
> >you need him? ;-)
> >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)
More information about the london.pm