Re: Transaction Queries!!!
От | Vatsal |
---|---|
Тема | Re: Transaction Queries!!! |
Дата | |
Msg-id | 1066194467.2277.17.camel@M3-113824 обсуждение исходный текст |
Ответ на | Re: Transaction Queries!!! (Stephan Szabo <sszabo@megazone.bigpanda.com>) |
Ответы |
Re: Transaction Queries!!!
|
Список | pgsql-general |
Thanks for the quick reply,
could you please elaborate or give me some pointers on Nested Transactions or Savepoints( which you are talking about in your reply to the first problem)
thanks in advance,
regards
vatsal
On Tue, 2003-10-14 at 23:49, Stephan Szabo wrote:
could you please elaborate or give me some pointers on Nested Transactions or Savepoints( which you are talking about in your reply to the first problem)
thanks in advance,
regards
vatsal
On Tue, 2003-10-14 at 23:49, Stephan Szabo wrote:
On Tue, 14 Oct 2003, Vatsal wrote: > We are using postgresql as the underlying RDBMS for one of our > application. When in a transaction if we execute an query that causes > database to return a failure. The whole transaction gets roll backed. Yes, all errors are treated as unrecoverable, so you're forced to roll the transaction back. At some point nested transactions or savepoints will let you have more control. > A another problem is of executing update query thru ODBC API's. When we > run update query thru executeQuery() API, even though the update query > may > not go thru as some column condition may not have met or the where > clause > may have been wrong. In such case also the API returns success. > > When the query is executed thru psql prompt it says zero rows updated. > Has this problem got to do with postgresql or ODBC API? An update that updates no rows is still a success by our general definition.
______________ |
**************************Disclaimer************************************ Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individualor entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. *************************************************************************** |
В списке pgsql-general по дате отправления: