public inbox for [email protected]help / color / mirror / Atom feed
Docs patch for REFRESH MATERIALIZED VIEW lock level 3+ messages / 2 participants [nested] [flat]
* Docs patch for REFRESH MATERIALIZED VIEW lock level @ 2015-11-02 01:58 Craig Ringer <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Craig Ringer @ 2015-11-02 01:58 UTC (permalink / raw) To: pgsql-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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Docs patch for REFRESH MATERIALIZED VIEW lock level @ 2015-11-02 13:05 Kevin Grittner <[email protected]> parent: Craig Ringer <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Kevin Grittner @ 2015-11-02 13:05 UTC (permalink / raw) To: Craig Ringer <[email protected]>; pgsql-docs On Sunday, November 1, 2015 7:59 PM, Craig Ringer <[email protected]> wrote: > The explicit locking docs mention the lock taken by REFRESH > MATERIALIZED VIEW CONCURRENTLY, but not plain REFRESH MATERIALIZED > VIEW. Patch. Pushed, with minor adjustment. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Docs patch for REFRESH MATERIALIZED VIEW lock level @ 2015-11-02 13:58 Craig Ringer <[email protected]> parent: Kevin Grittner <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Craig Ringer @ 2015-11-02 13:58 UTC (permalink / raw) To: Kevin Grittner <[email protected]>; +Cc: pgsql-docs On 2 November 2015 at 21:05, Kevin Grittner <[email protected]> wrote: > On Sunday, November 1, 2015 7:59 PM, Craig Ringer <[email protected]> wrote: > >> The explicit locking docs mention the lock taken by REFRESH >> MATERIALIZED VIEW CONCURRENTLY, but not plain REFRESH MATERIALIZED >> VIEW. Patch. > > Pushed, with minor adjustment. Thanks. I try to immediately write patches for small stuff like this, otherwise it gets lost and forgotten again. -- 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2015-11-02 13:58 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2015-11-02 01:58 Docs patch for REFRESH MATERIALIZED VIEW lock level Craig Ringer <[email protected]> 2015-11-02 13:05 ` Kevin Grittner <[email protected]> 2015-11-02 13:58 ` Craig Ringer <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox