[ppa-help] [ phppgadmin-Bugs-3579602 ] escapeBytea returns "x" for blank strings

[SourceForge.net <no...@so...>]

Bugs item #3579602, was opened at 2012-10-23 18:32
Message generated for change (Comment added) 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.

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

>Comment By: Rick Yorgason (skrapion)
Date: 2012-10-23 18:37

Message:
I just realized my first sentence might be confusing since I'm using the
term 'field' in two different ways.

What I meant to say is, if you have a table with a bytea field and try to
use the 'Select' action on it (ie tables.php?action=confselectrows), it
fills the textarea next to the bytea column with an 'x' character.

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3579602&group_id=37132