Re: DELETE...RETURNING problem with libpq

Hi Brice,

I believe that you'll need PQcmdTuples - "Returns the number of rows
affected by the SQL command."

Watch out, it returns char* instead of int. I believe it's supposed to
be used for the UPDATE ... RETURNING as well, but I'd double check on
that.

It's under "30.3.3. Retrieving Result Information for Other Commands"
in the 8.4 docs ("These functions are used to extract information
from PGresult objects that are not SELECT results."):

[1]http://www.postgresql.org/docs/8.4/static/libpq-exec.html

Let us know if that helps or if we should dig into it a little deeper.

Best regards,

Wolfe

--
Wolfe Whalen
wolfe(at)quios(dot)net

On Sat, May 25, 2013, at 04:07 AM, Brice André wrote:

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.

References

1. http://www.postgresql.org/docs/8.4/static/libpq-exec.html