Re: [BUGS] pg_dump(1) failures when concurrently refreshing mat views

Поиск
Список
Период
Сортировка
От Nico Williams
Тема Re: [BUGS] pg_dump(1) failures when concurrently refreshing mat views
Дата
Msg-id 20170419212356.GA2844@localhost
обсуждение исходный текст
Ответ на Re: [BUGS] pg_dump(1) failures when concurrently refreshing mat views  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [BUGS] pg_dump(1) failures when concurrently refreshing mat views  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения 
On Wed, Apr 19, 2017 at 05:20:31PM -0400, Tom Lane wrote:
> Nico Williams <nico@cryptonector.com> writes:
> > pg_dump(1) gets an EXCLUSIVE LOCK with NOWAIT
> 
> ... uh, really?  It's not supposed to take anything higher than ACCESS
> SHARE, which should coexist fine with anything short of ACCESS EXCLUSIVE.

Whoops, sorry, that's a mistake in drafting the report.  You're right,
it takes an ACCESS SHARE MODE lock, NOWAIT.  The remainder of the report
remains correct.

Nico
-- 


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] pg_dump(1) failures when concurrently refreshing mat views
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [BUGS] BUG #14626: array_agg( anyarray ) unexpected error withmulti-valued single-dimension array