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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Nico Williams <nico(at)cryptonector(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: pg_dump(1) failures when concurrently refreshing mat views
Date: 2017-04-19 21:20:31
Message-ID: 31589.1492636831@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Nico Williams <nico(at)cryptonector(dot)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.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Nico Williams 2017-04-19 21:23:56 Re: pg_dump(1) failures when concurrently refreshing mat views
Previous Message Tom Lane 2017-04-19 21:03:52 Re: BUG #14626: array_agg( anyarray ) unexpected error with multi-valued single-dimension array