Hi Jeroen and Everyone,
I'm hoping that someone can explain this to me.
When I try to update a row that does not exist in a table (the table is empty as a matter of fact), the query does not fail - Instead it executes successfully but obviously the row still does not exist and therefore the query does nothing.
When running the query from a program the "result::affected_rows()" function returns 0. I get the same result when running the query from the command line.
Should the query not fail? Surely trying to update a row that does not exist should result in some type of error? In DB2 the query will return a "not found" error code as the row you are trying to update does not exist. (obviously Postgre is not DB2).
Anyone else come across this?
I suppose it's not such a big deal - but it does raise some questions about the inner workings of the DBMS though.
Thanks in advance.
Cheers,
Hannes Wagener
Ext: 55453
Tel: (+27) 11 631 5453
Cell: (+27) 82 852 7250
This e-mail, its attachments and any rights attaching hereto are, unless the context clearly indicates otherwise, the property of Standard Bank Group Limited and/or its subsidiaries ("the Group"). It is confidential, private and intended for the addressee only.
Should you not be the addressee and receive this e-mail by mistake, kindly notify the sender, and delete this e-mail, immediately and do not disclose or use same in any manner whatsoever. Views and opinions expressed in this e-mail are those of the sender unless clearly stated as those of the Group. The Group accepts no liability whatsoever for any loss or damages whatsoever and howsoever incurred, or suffered, resulting, or arising, from the use of this email or its attachments.
The
Group does not warrant the integrity of this e-mail
nor that it is free of errors, viruses, interception or interference.
Licensed
divisions of the Standard Bank Group are authorised financial services providers
in terms of the Financial Advisory and Intermediary Services Act, No 37 of 2002
(FAIS).
For information about the Standard Bank Group Limited visit our website http://www.standardbank.co.za
_________________________________________________________________________________________________________________________________________________________________________________ Libpqxx-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/libpqxx-general
