[imp] VFS+PostgreSQL+Attachment Upload

Igor Stroh stroh@scan-plus.de
01 Oct 2002 13:04:00 +0200


Hi all,

I have problems getting sql VFS from HEAD to run properly.
I have a postgres (7.2.1) running as sql backend. If I try to upload a
binary file in the compose view with $conf['compose']['use_vfs'] = true;
and print out pg_last_error() I get "ERROR: Unterminated quoted string".
It seems like the quote method from PEAR/DB/pgsql.php fails to quote the
data string properly (both, php4 and PEAR package are from
debian/woody). The vfs_data field in the horde_vfs table is declared as
BYTEA (postgres data type that can be used for storing BLOBs). Any ideas
how to solve this problem?

TIA,
Igor