Proper use of Transactions...
| От | Matthew Hagerty |
|---|---|
| Тема | Proper use of Transactions... |
| Дата | |
| Msg-id | 4.1.19990808155400.009f43c0@mail.venux.net обсуждение исходный текст |
| Ответы |
Re: [INTERFACES] Proper use of Transactions...
|
| Список | pgsql-interfaces |
Greetings, If I write a transaction like this: begin transaction; . . . commit transaction; and an error occurs somewhere in the middle, do I have to issue a rollback command or will PostgreSQL do that automatically on an error? The problem I think I am having is that if some command between the begin and commit statements causes an error, my program terminates, so I do not have an opportunity to issue a rollback. All this is compounded because I am using PHP3 as an Apache module to access PostgreSQL and I am receiving the following error in my Apache log: NOTICE: (transaction aborted): queries ignored until END I'm not sure where to start looking for the problem. Any insight would be greatly appreciated. Thank you, Matthew
В списке pgsql-interfaces по дате отправления: