DELETE...RETURNING problem with libpq

Поиск
Список
Период
Сортировка
От Brice André
Тема DELETE...RETURNING problem with libpq
Дата
Msg-id CAOBG12=oT4ghBHgO+z-scf4fDEeMwunPBGbdi2ES9CoPPSy4Nw@mail.gmail.com
обсуждение исходный текст
Список pgsql-sql
Дерево обсуждения
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.

В списке pgsql-sql по дате отправления: