Rule updates and PQcmdstatus() issue - Mailing list pgsql-hackers

From Steve Howe
Subject Rule updates and PQcmdstatus() issue
Date
Msg-id 151128738375.20020906151015@carcass.dhs.org
Whole thread Raw
Responses Re: Rule updates and PQcmdstatus() issue  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Hello all,

PostgreSQL *still* has a bug where PQcmdStatus() won't return the
number of rows updated. But that is essential for applications, since
without it of course we don't know if the updates/delete/insert
commands succeded. Even worst, on interfaces like Delphi/dbExpress the
program will return an error message and rollback transaction thinking
nothing have been updated. In other words, unusable.

This render views useless (I either use view with rules and don't get
my program working) and won't allow me to proper use security settings
on PostgreSQL...

This is a *major* issue in my opinion that appeared on a May thread
but I can't see it done on version 7.2.2. Even worst, I can't see
nothing on the TODO file.

Will this fix finally  appear on 7.3 ? Any ways to work around this ?
How can I know at least if *something* succeeded, or how many rows
(the proper behavior)?

Thank you very much.

------------- 
Best regards,Steve Howe                           mailto:howe@carcass.dhs.org



pgsql-hackers by date:

Previous
From: elein
Date:
Subject: Re: Inheritance
Next
From: snpe
Date:
Subject: Re: problem with new autocommit config parameter and jdbc