[ openjms-Bugs-744331 ] messages.messageBlob using wrong field type in PostgreSQL

Bugs item #744331, was opened at 2003-05-27 15:29
Message generated for change (Comment added) made by tanderson
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=744331&group_id=54559

Category: persistence
Group: v0.7.4
>Status: Closed
>Resolution: Fixed
Priority: 5
Submitted By: Juan Carlos Estibariz (jcestiba)
>Assigned to: Tim Anderson (tanderson)
Summary: messages.messageBlob using wrong field type in PostgreSQL

Initial Comment:
messages.messageBlob is declared as varchar in 
config/create_postgresql.sql but, since it stores 
binary data, it can lead to encoding errors. 
 
The field should be declared as 'bytea' (see attached 
patch). 

----------------------------------------------------------------------

>Comment By: Tim Anderson (tanderson)
Date: 2003-05-30 09:59

Message:
Logged In: YES 
user_id=557161

Patch applied thanks.

Will be available in the 0.7.6 release.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=744331&group_id=54559