Dear all, I am trying to translate a code written in php to C++. So, I am now using lipq in order to access my postgresql database from C++.
As performance is an important feature, I am using prepared statements. I have a SQL statement that performs a 'DELETE ... RETURNING ... ' stuff and I execute it from a prepared statement (using PQprepare and PQexecPrepared). Now, when I execute this command, it properly deletes requested row, but when I use command PQntuples, it returns 0, as if no data was returned. When I execute the same sql command from PgAdmin or from my old php script (that did not use prepared statements), everything works fine. Note that, in another part of my script, I use the same technique to perform an 'UPDATE ... RETURNING' and it works properly... Does anyone has an idea of what may fail and how I can solve this problem ? Regards, Brice PS : my postgresql server version is 8.4 and it is running on a Debian server, if it may help.
