Re: IDLE IN TRANSACTION

Поиск
Список
Период
Сортировка
От Rodrigo Sakai
Тема Re: IDLE IN TRANSACTION
Дата
Msg-id 004a01c663e2$4860a5d0$4700a8c0@TREEZANTHUS
обсуждение исходный текст
Ответ на Re: IDLE IN TRANSACTION  ("Andy Shellam" <andy.shellam@mailnetwork.co.uk>)
Ответы Re: IDLE IN TRANSACTION  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-admin

>No problem really, all it means is the application has issued a start of transaction command, it just isn’t doing anything at the moment.


>Transactions allow any data added during the application’s running to be rolled back should, for example, the application crash – it’ll prevent half-written data remaining >stale in your database.

>My guess is when you Exit the application correctly, it’ll issue a COMMIT statement to store the transactional data to your database.

 

  Ok Andy, but what if I do an UPDATE operation on the database within this transaction, it will acquire exclusivelock on that table and will release only at the commit (or rollback) of this transaction, is that right?? So, if this transaction only finishes with the exit of the application the UPDATE operation will cause a lot of locks and deadlocks, won't they???

 

  Thanks!

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Chandra Sekhar Surapaneni"
Дата:
Сообщение: Re: IDLE IN TRANSACTION
Следующее
От: Arnau
Дата:
Сообщение: Schema synchronization