pg_Exec: Warning: 1 is not a valid PostgreSQL link resource.

From: Date: Fri, 02 Feb 2001 13:53:33 +0000
Subject: pg_Exec: Warning: 1 is not a valid PostgreSQL link resource.
Groups: php.general 
Request: Send a blank email to php-general+get-37833@lists.php.net to get a copy of this message
Hi! We have a host (host A) with PostgreSQL 7.0.3. and PHP 4.0.4 under Red Hat We have another host (host B) with PHP 4.0.3pl1 under Debian We are having an incomprehensible error with this code when the content of $sql is and "update" ... $resultado=pg_Exec($conexion,$sql); ... 1) The php code from host A works ok. 2) The same php code from host B accessing postgresql database on host A does not work with "update", but it works with "select", "insert", and "delete". 3) If I try from host B: psql -h hostA -d database -u update fam set nom='xxxxxx' where id='23' it works ok. 4) So, where is the problem? php4 libraries under Debian distribution? Any ideas? -- Evelio Martínez Testanet. Dept. desarrollo software. Av. Reino de Valencia, 15 - 5 46005 Valencia (Spain) Tel: +34 96 395 90 00 Fax: +34 96 316 23 19

« previous php.general (#37833) next »