From: SourceForge.net <no...@so...> - 2012-10-24 01:32:59
|
Bugs item #3579602, was opened at 2012-10-23 18:32 Message generated for change (Tracker Item Submitted) made by skrapion You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3579602&group_id=37132 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Tables Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Rick Yorgason (skrapion) Assigned to: Nobody/Anonymous (nobody) Summary: escapeBytea returns "x" for blank strings Initial Comment: When selecting from a table with a bytea field, the field is automatically filled with a single "x" character, meaning you have to clear it before an actual selection will work. The problem is a result of the call to pg_escape_bytea in Postgres::escapeBytea (classes/database/Postgres.php). For some reason, when pg_escape_bytea("") is called in this function, it returns "\\x". The confusing part is that if I write a script that does nothing but print the output of pg_escape_bytea(""), it returns an empty string as expected. I haven't figured out what phpPgAdmin does to alter the behaviour of this function. I'm currently using phpPgAdmin 5.0.3-1, PostgreSQL 9.1+129ubuntu1, Apache 2.2.22-1ubuntu1, and php 5.3.10-1ubuntu3.4 under Ubuntu 12.04.1 LTS. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3579602&group_id=37132 |