Email::Store::Attachment - my losing battle
c.jones at ucl.ac.uk
Fri Dec 1 14:43:34 GMT 2006
Not a PostgreSQL user, and not a techy - so take everything I say with
a pinch of salt!
But googling didn't satisfy me that it does - on the guide I found,
there was no sign of a type called 'BLOB'. And it didn't seem that the
bytea type is equivalent.
Maybe someone who knows/understands more than me can explain!
On 1 Dec 2006, at 10:25, Toby Corkindale wrote:
> 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
> Things fall apart, the centre cannot hold/Mere anarchy is loosed upon
> the world
> (gpg --keyserver www.co.uk.pgp.net --recv-key B1CCF88E)
UCL Translational Research Laboratory
46 Cleveland Street
Telephone: 020 7679 9204
Fax: 020 7679 9243
More information about the london.pm