Received: from maria.xpress.es (bestia.xpress.es [194.224.86.3])
	by hub.org (8.9.3/8.9.3) with ESMTP id EAA83082
	for <pgsql-interfaces@postgreSQL.org>;
	Thu, 23 Dec 1999 04:01:47 -0500 (EST)
	(envelope-from enrique@xpress.es)
Received: from xpress.es (idefix.xpress.es [194.224.86.59])
	by maria.xpress.es (8.8.8/8.8.8) with ESMTP id JAA18799
	for <pgsql-interfaces@postgreSQL.org>; Thu, 23 Dec 1999 09:56:29 GMT
Sender: enrique@bestia.xpress.es
Message-ID: <3861E550.8ED9448@xpress.es>
Date: Thu, 23 Dec 1999 10:03:12 +0100
From: Enrique Rodriguez Lazaro <enrique@xpress.es>
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.0.36 i586)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-interfaces@postgreSQL.org
Subject: Ghost insert
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

 Hi.
 
 I am trying to do a interface from a web over my database postgresql
 whit libpq.
 
 I can't do a simple 'insert' from libpq.
 
 I'm doing this:
 
 sprintf(temp_string,"insert into clientes
 values('fff','prueba','123','123','pepe gotera','jjjjjj','jjj')");
 
 res1=PQexec(conn,temp_string);
 tuplas=PQresultStatus(res1);
 imprime_cab_html(0);
 
 printf("Resultado: %s<br><p>\n",PQresStatus(tuplas));
 printf("Temp_string: %s\n",temp_string);
 
 *****
 
 And the result on my web it's OK:
 
 Resultado: PGRES_COMMAND_OK
 
 Temp_string: insert into clientes
 values('fff','prueba','123','123','pepe gotera','jjjjjj','jjj')
 
 But the insert hasn't effect on my database. If from my database i do
 'select * from clientes;' the result it's empty.
 
 Where it's the problem?.
 
 Thanks in advanced.
 
 ************