Thus spake Enrique Rodriguez Lazaro
> > Just guessing here but is it possible that clientes is a view and you are
...
> > If the above is not your problem then you might also try PQoidStatus(res1)
> > to see what the resulting OID is.
>
> clientes is a table, isn't a view.
Wow. This is really strange.
> 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*/
That is correct.
> 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
Well, this definitely means that it was inserted.
> If nobody run the query insert from the prompt of psql, the insert have
> effect. It's ok.
>
>
> Where it's the problem?
It's a poser. Here is another, even wilder guess. Could your program
be connecting to a different (test?) version of the database? Does it
run on a different machine and you don't have the host argument perhaps?
Do other tables work as expected? Are you doing a proper disconnect
from the database at the end?
--
D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
************
