public inbox for [email protected]
help / color / mirror / Atom feedFrom: Craig Ringer <[email protected]>
To: [email protected]
Subject: Docs patch for REFRESH MATERIALIZED VIEW lock level
Date: Mon, 2 Nov 2015 09:58:33 +0800
Message-ID: <CAMsr+YEAqciKmsoaOnycezT9ZMTULf=biU8JAxjLYWbLqBin9A@mail.gmail.com> (raw)
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>
The explicit locking docs mention the lock taken by REFRESH
MATERIALIZED VIEW CONCURRENTLY, but not plain REFRESH MATERIALIZED
VIEW. Patch.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Attachments:
[text/x-patch] 0001-Mention-lock-level-of-REFRESH-MATERIALIZED-VIEW.patch (1.1K, 2-0001-Mention-lock-level-of-REFRESH-MATERIALIZED-VIEW.patch)
download | inline diff:
From d24f44836b6f7358fcea5c7d2aebf8a6522b6a41 Mon Sep 17 00:00:00 2001
From: Craig Ringer <[email protected]>
Date: Mon, 2 Nov 2015 09:57:02 +0800
Subject: [PATCH] Mention lock level of REFRESH MATERIALIZED VIEW
---
doc/src/sgml/mvcc.sgml | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
diff --git a/doc/src/sgml/mvcc.sgml b/doc/src/sgml/mvcc.sgml
index 5128982..396a5ba 100644
--- a/doc/src/sgml/mvcc.sgml
+++ b/doc/src/sgml/mvcc.sgml
@@ -990,7 +990,8 @@ ERROR: could not serialize access due to read/write dependencies among transact
<para>
Acquired by the <command>DROP TABLE</>,
<command>TRUNCATE</command>, <command>REINDEX</command>,
- <command>CLUSTER</command>, and <command>VACUUM FULL</command>
+ <command>CLUSTER</command>, <command>VACUUM FULL</command>
+ and <command>REFRESH MATERIALIZED VIEW</command>
commands. Many forms of <command>ALTER TABLE</> also acquire
a lock at this level. This is also the default lock mode for
<command>LOCK TABLE</command> statements that do not specify
--
2.1.0
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Docs patch for REFRESH MATERIALIZED VIEW lock level
In-Reply-To: <CAMsr+YEAqciKmsoaOnycezT9ZMTULf=biU8JAxjLYWbLqBin9A@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox