Waiting on a transaction

Поиск
Список
Период
Сортировка
От Bill Moseley
Тема Waiting on a transaction
Дата
Msg-id 20050816180535.GA8845@hank.org
обсуждение исходный текст
Ответы Re: Waiting on a transaction
Список pgsql-general
I've read over the docs on Concurrency Control but still not clear
about when transactions block other updates, and how to deal with that
on the application level.

If I do a BEGIN and an UPDATE in one psql session and then try and do
an UPDATE in another psql session that UPDATE waits until either a
COMMIT or ROLLBACK.

Is it common for applications using Postgresql to set a timer on
updates and abort?


--
Bill Moseley
moseley@hank.org


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