Re: [INTERFACES] Ghost insert

"D'Arcy J.M. Cain" wrote:
> 
> Thus spake Enrique Rodriguez Lazaro
> >  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.
> 
> Just guessing here but is it possible that clientes is a view and you are
> seeing the underlying table when you select after the insert?  In PostgreSQL,
> views are real tables.  They just have an implied rule on select that gets
> data from a SELECT statement instead of the named table.  See the following
> URL for more details.
> 
>     http://www.postgresql.org/docs/programmer/rules890.htm
> 
> >  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);
> 
> If the above is not your problem then you might also try PQoidStatus(res1)
> to see what the resulting OID is.
> 


I can't resolve the problem.

clientes is a table, isn't a view.

All it's correct with respect the distints solutions that i have
recived. The last time i have put this on my C program: 
        sprintf(temp_string,"insert into clientes
values('f','p','1','23','pepe gotera','j,'j')");

/* NOTE: the ';' it's not necesary*/
         res1=PQexec(conn,temp_string);         tuplas=PQresultStatus(res1);         imprime_cab_html(0);
         printf("Status: %s<br><p>\n",PQoidStatus(res1));         printf("Resultado: %s<br><p>\n",PQresStatus(tuplas));
       printf("Temp_string: %s\n",temp_string);
 
         printf("</body></html>");


And the result it's this:
Status: 19648
Resultado: PGRES_COMMAND_OK
Temp_string: insert into clientes values('f','p','1','23','pepe
gotera','j','j') 


That's the clientes table:
\d clientes
Table    = clientes
+----------------------+----------------------------------+-------+
|  Field               |              Type                | Length|
+----------------------+----------------------------------+-------+
| id_cli               | text not null                    |   var |
| empresa              | text                             |   var |
| nif                  | text                             |   var |
| ubicacion            | text                             |   var |
| telefono             | text                             |   var |
| contacto             | text                             |   var |
| observaciones        | text                             |   var |
+--------------- ------+----------------------------------+-------+
Index:    clientes_pkey


The permissions over this database are:

> \z
Database    = xpress+---------------+--------------------------+| Relation      | Grant/Revoke Permissions
|+---------------+--------------------------+|clientes      | {"=","nobody=arwR"}      || comerciales   |
{"=","nobody=arwR"}     || prueba        | {"=","nobody=arwR"}      || prueba_id_seq |                          || seq1
        |                          || tecnicos      | {"=","nobody=arwR"}      |
 


'nobody' is the apache user.

If nobody run the query insert from the prompt of psql, the insert have
effect. It's ok.


Where it's the problem?


Thanks in advanced.