Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] pg_dump(1) failures when concurrently refreshing mat views - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] pg_dump(1) failures when concurrently refreshing mat views
Date
Msg-id 31589.1492636831@sss.pgh.pa.us
Whole thread Raw
In response to [BUGS] pg_dump(1) failures when concurrently refreshing mat views  (Nico Williams <nico@cryptonector.com>)
Responses Re: [BUGS] pg_dump(1) failures when concurrently refreshing mat views  (Nico Williams <nico@cryptonector.com>)
List pgsql-bugs
Tree view 
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.
        regards, tom lane


-- 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14626: array_agg( anyarray ) unexpected error with multi-valued single-dimension array
Next
From: Nico Williams
Date:
Subject: Re: [BUGS] pg_dump(1) failures when concurrently refreshing mat views