[php-maint] Bug#773182: php5-pgsql: pg_lo_export does not work with postgesql 9.1

[Friedhelm Mehnert]

Package: php5-pgsql
Version: 5.4.35-0+deb7u2
Severity: normal

Dear Maintainer,

this is about a problem with the php5-pgsql package.

It works fine and as expectet with postgresql 8.4.

However after upgrading to postgresql 9.1 the pg_lo_export function does
not work.

It returnes TRUE, the file is created, but has zero length and does not
contain the BLOB.

The Problem is neither with postgresql 9.1, nore with libpq, because it
works fine from the pgsql-client.

Something like 
   SELECT lo_export(coverdat.cover, "/tmp/HONK") from coverdat WHERE maj = 77;

works fine!

Calling the funktion from within php5
i.e.
   function my_coverdat ($handle, $major, $tmp_name) {
   $full_name = '/tmp/HONK';
   $my_oid = my_get_oid ($handle, $major);
   pg_query($handle, "begin");
   $result = pg_lo_export($handle, $my_oid, $full_name);
   pg_query($handle, "commit");
}

does not.

$result is TRUE, but the file HONK is empty!

The same unmodified funktion works fine with postgresql 8.4.

Sorry if this description is kind of unclear, but I'm not a programmer.

Regards Friedhelm


-- System Information:
Debian Release: 7.7
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 3.2.0-4-686-pae (SMP w/1 CPU core)
Locale: LANG=C, LC_CTYPE=en_US.utf8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages php5-pgsql depends on:
ii  dpkg                                       1.16.15
ii  libapache2-mod-php5 [phpapi-20100525+lfs]  5.4.35-0+deb7u2
ii  libc6                                      2.13-38+deb7u6
ii  libpq5                                     9.1.14-0+deb7u1
ii  php5-common                                5.4.35-0+deb7u2
ii  ucf                                        3.0025+nmu3

php5-pgsql recommends no packages.

php5-pgsql suggests no packages.

-- no debconf information