Re: BUG #8290: broken/unexpected locking behavior

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: BUG #8290: broken/unexpected locking behavior
Дата
Msg-id 20130709205357.GI18471@eldon.alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: BUG #8290: broken/unexpected locking behavior  (Jamey Poirier <jpoirier@exagrid.com>)
Ответы Re: BUG #8290: broken/unexpected locking behavior  (pg noob <pgnube@gmail.com>)
Список pgsql-bugs
Jamey Poirier escribió:
>
> Thank you Alvaro.  Yes, this explains it.
> It doesn't help to fix it but at least I know now that it's a known "feature".
> I'll have to see about coming up with a work-around as we likely won't get to 9.3 anytime soon.

Perhaps you can use FOR SHARE instead of FOR UPDATE in the first
connection, for instance ..

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #8289: pg_stat_statements incorrect query text when executing multiple queries in a single PQexec
Следующее
От: lalbin@fhcrc.org
Дата:
Сообщение: BUG #8291: postgres_fdw does not re-read USER MAPING after change.