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 -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org