Fundamental change of locking behavior in 7.1

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема Fundamental change of locking behavior in 7.1
Дата
Msg-id 11C1E6749A55D411A9670001FA687963368125@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Ответы RE: Fundamental change of locking behavior in 7.1
Список pgsql-hackers
Since I see, that Tom has implemented the "keep a AccessShareLock lock until 
transaction end" philisophy I would like to state a protest.

This is a fundamental change in behavior and I would like to see 
a vote on this.

The one example we already know is:

session1                session2
begin work;                begin work;
select * from tenk1 limit 1;                select * from tenk1 limit 1;
lock table tenk1; --now waits (why should it ?)                lock table tenk1; -- NOTICE:  Deadlock detected -->
ABORT

I think this is not acceptable in committed read isolation. The AccessShareLock
needs to be released after each statement finishes.

Thank you
Andreas


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