Rails - Jan 2005 - PostgreSQL and binary data

I have a "bytea" column in PostgreSQL that I''m trying to
stuff binary
data into. The same works fine with MySQL, but the PostgreSQL database 
adapter tries to insert the binary data as pure text, which fails:

ERROR: unterminated quoted string at or near "..."  at character 28: 
UPDATE photos SET "data" = ...

This works fine with the MySQL adapter. I''m thinking perhaps the
adapter
doesn''t correctly identify "bytea" columns as being binary.
Known bug?

Alexander.

Oh, and following this error, Ruby proceeds to eat up all virtual memory 
until it dies or is killed by the kernel process killer.

Alexander.

Alexander Staubo wrote:
> I have a "bytea" column in PostgreSQL that I''m trying to
stuff binary
> data into. The same works fine with MySQL, but the PostgreSQL database 
> adapter tries to insert the binary data as pure text, which fails:
> 
> ERROR: unterminated quoted string at or near "..."  at character
28:
> UPDATE photos SET "data" = ...
> 
> This works fine with the MySQL adapter. I''m thinking perhaps the
adapter
> doesn''t correctly identify "bytea" columns as being
binary. Known bug?
> 
> Alexander.
> _______________________________________________
> Rails mailing list
> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
> http://lists.rubyonrails.org/mailman/listinfo/rails

Alexander Staubo wrote:
> I have a "bytea" column in PostgreSQL that I''m trying to
stuff binary
> data into. The same works fine with MySQL, but the PostgreSQL database 
> adapter tries to insert the binary data as pure text, which fails:
If anyone is interested, I''ve submitted a patch which fixes this:

   http://dev.rubyonrails.org/ticket/444

Alexander.