Rule updates and PQcmdstatus() issue

From: Steve Howe <howe(at)carcass(dot)dhs(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Rule updates and PQcmdstatus() issue
Date: 2002-09-06 18:10:15
Message-ID: 151128738375.20020906151015@carcass.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)carcass(dot)dhs(dot)org

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-09-06 18:22:13 Re: Rule updates and PQcmdstatus() issue
Previous Message elein 2002-09-06 18:00:01 Re: Inheritance