Bug #16953 Updated: problem with "bytea" column

ID: 16953 Updated by: yohgaki@php.net Reported By: stach@toya.net.pl Status: Bogus Bug Type: PostgreSQL related Operating System: Win32 PHP Version: 4.2.0 New Comment: BTW, bytea is _very_ slow compare to large object. Bytea could be 40, 50 times slower than lo. AND PHP pgsql module does not provide decode function when you select bytea. This makes slower. I suggest to wait PostgreSQL 7.3 and PHP supports it or use lo now. Previous Comments: ------------------------------------------------------------------------ [2002-05-02 10:14:41] yohgaki@php.net I think this is PostgreSQL problem under Windows. You are better to ask to PostgreSQL windwos users/developers. ------------------------------------------------------------------------ [2002-05-01 17:11:28] stach@toya.net.pl Apache 1.3.24 on Win32 (Win 2000), php installed as module. PostgreSQL 7.2.1 on Linux (Debian). When trying to select data from a column of type "bytea" with query "select encode(zdjecie, 'base64') as zdjecie" from php, I get the following error: pg_exec() query failed: pqReadData() -- read() failed: errno=0 No error However, the same code works well (on the same database), when called from php 4.1.2 apache 1.3.24 on Linux (Debian). Error reporting is set to E_ALL & ~E_NOTICE. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=16953&edit=1