Re: [GENERAL] inserting bytea using PHPs pg_escape_bytea()

2011-10-20 Thread Jeff Davis
On Thu, 2011-10-20 at 14:13 -0300, Martín Marqués wrote: > How would that work with abstraction layers like MDB2 or PDO? I'm not sure. If there isn't some way to use parameterized queries, then it's not a very good abstraction layer, in my opinion (because parameterized queries are widely recogniz

Re: [GENERAL] inserting bytea using PHPs pg_escape_bytea()

2011-10-20 Thread Martín Marqués
El día 20 de octubre de 2011 14:28, Rodrigo Gonzalez escribió: > El 20/10/11 14:13, Martín Marqués escribió: > > El día 19 de octubre de 2011 23:20, Jeff Davis escribió: > > On Wed, 2011-10-19 at 14:30 -0300, Martín Marqués wrote: > > The only concern I have is that on insertion, I get this WARNI

Re: [GENERAL] inserting bytea using PHPs pg_escape_bytea()

2011-10-20 Thread Rodrigo Gonzalez
El 20/10/11 14:13, Martín Marqués escribió: El día 19 de octubre de 2011 23:20, Jeff Davis escribió: On Wed, 2011-10-19 at 14:30 -0300, Martín Marqués wrote: The only concern I have is that on insertion, I get this WARNING: WARNING: nonstandard use of \\ in a string literal at character 41 H

Re: [GENERAL] inserting bytea using PHPs pg_escape_bytea()

2011-10-20 Thread Martín Marqués
El día 19 de octubre de 2011 23:20, Jeff Davis escribió: > On Wed, 2011-10-19 at 14:30 -0300, Martín Marqués wrote: >> The only concern I have is that on insertion, I get this WARNING: >> >> WARNING:  nonstandard use of \\ in a string literal at character 41 >> HINT:  Use the escape string syntax

Re: [GENERAL] inserting bytea using PHPs pg_escape_bytea()

2011-10-19 Thread Jeff Davis
On Wed, 2011-10-19 at 14:30 -0300, Martín Marqués wrote: > The only concern I have is that on insertion, I get this WARNING: > > WARNING: nonstandard use of \\ in a string literal at character 41 > HINT: Use the escape string syntax for backslashes, e.g., E'\\'. > > Should I worry? What does it

[GENERAL] inserting bytea using PHPs pg_escape_bytea()

2011-10-19 Thread Martín Marqués
I have some scripts that upload some images to the DB, specifically to a bytea column. For that I use PHPs (all scripts are in PHP) pg_escape_bytea (and pg_unescape_bytea after extraction) before inserting. Images go good in the DB and are shown correctly after extraction, so it looks like there is