search

LibreCat / Catmandu-DBI

A Catmandu::Store plugin for DBI based interfaces
Other
0 stars 1 forks source link

sql update postgres needs type PG_BYTEA #5

Closed nicolasfranck closed 10 years ago

nicolasfranck commented 10 years ago

The parameter "data" needs to be binded explicitely as type DBD::PG::PG_BYTEA in order to be properly escaped:

http://search.cpan.org/~rudy/DBD-Pg/Pg.pm https://rt.cpan.org/Public/Bug/Display.html?id=13180

If not, this error occurs:

DBD::Pg::st execute failed: ERROR:  invalid input syntax for type bytea