Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Zt4OO-0008Cm-D6 for pgsql-docs@arkaria.postgresql.org; Mon, 02 Nov 2015 01:58:40 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1Zt4ON-0006jD-Oy for pgsql-docs@arkaria.postgresql.org; Mon, 02 Nov 2015 01:58:39 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1Zt4OM-0006ik-Qb for pgsql-docs@postgresql.org; Mon, 02 Nov 2015 01:58:38 +0000 Received: from mail-lb0-x22c.google.com ([2a00:1450:4010:c04::22c]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1Zt4OJ-0003fk-Pl for pgsql-docs@postgresql.org; Mon, 02 Nov 2015 01:58:37 +0000 Received: by lbbes7 with SMTP id es7so78471270lbb.2 for ; Sun, 01 Nov 2015 17:58:33 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant_com.20150623.gappssmtp.com; s=20150623; h=mime-version:date:message-id:subject:from:to:content-type; bh=K7iKWznPWfnc7ZndCtEfDLlNdVIuBK24QW49QEpa//M=; b=V2hrEjKbaAJ/WZvNhFD0/6xRvOuMUWAHBOW1oVxG0GPeVM6Ju1GH3W6pu/Jc3HwFsf Jju6rhO36QfQSv+PL9neLKnsl6Q9mAAB1HmI7nd9HcV6tvteU6JaKxwSIXPzBDIT5gQC Fa2R2upDryJkCUHVMS03Fmwxq/NQgRYTiAfuc8CWoRXGrtMgYOMkfmVlv78YGRtpYHPZ UkA7fB9t3yuxYFP3U6copzuqFVjnaAd+9J/zZ5HW13AJJox+VTzIN5BaNCjodwFicKyZ KmTluDdBATKUMhh0aM8bOxMKAiyDxWyCinWC6YYdlm5sgeLOgUZ3X+PLUNbhvVvC9fgQ ggWQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:date:message-id:subject:from:to :content-type; bh=K7iKWznPWfnc7ZndCtEfDLlNdVIuBK24QW49QEpa//M=; b=WUfAXnuDGv5fDuUDB/Cg1YKkL6R0jRDfVuy4I6dSIOsPqyHtc0JGnUmpUmcBHZSKjz 7ts+ILHY+lwd1GEUWkELKNFBYHi9iWQ/coTopz0H3DCUBd2UI1AHc8mF6+0PIIhsL3vP JK31nvnp1D3Wx5vGzladj72aKIz/sV4oAEGFFsQiafFqaJFOB7U9ibHZNaQ/E7FP70oN ScMzsaDpMpHUkHE2uW2ZDc5KPr5qxq6EdoN9SIBHxk1WFEjeAMQZ1w5GFcdAle7iYNt8 MhaRP9mjwb2t8x9Vg2xUSOkxpOdknaeOzWJOtnHtRWszN3U7G9miIjBrBPSeFx0ZSvh3 aV9w== X-Gm-Message-State: ALoCoQkMa6nxAXJq8ocYlAc/ZMKC+l4MKPSlTc643todyEQlEyO1+xSqI6YuC7KiZG8ERI+Mwbao MIME-Version: 1.0 X-Received: by 10.112.130.195 with SMTP id og3mr8981848lbb.69.1446429513447; Sun, 01 Nov 2015 17:58:33 -0800 (PST) Received: by 10.114.186.74 with HTTP; Sun, 1 Nov 2015 17:58:33 -0800 (PST) Date: Mon, 2 Nov 2015 09:58:33 +0800 Message-ID: Subject: Docs patch for REFRESH MATERIALIZED VIEW lock level From: Craig Ringer To: pgsql-docs@postgresql.org Content-Type: multipart/mixed; boundary=047d7b3a83aa57bc490523851de8 X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org --047d7b3a83aa57bc490523851de8 Content-Type: text/plain; charset=UTF-8 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 --047d7b3a83aa57bc490523851de8 Content-Type: text/x-patch; charset=US-ASCII; name="0001-Mention-lock-level-of-REFRESH-MATERIALIZED-VIEW.patch" Content-Disposition: attachment; filename="0001-Mention-lock-level-of-REFRESH-MATERIALIZED-VIEW.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_igharqqa0 RnJvbSBkMjRmNDQ4MzZiNmY3MzU4ZmNlYTVjN2QyYWViZjhhNjUyMmI2YTQx IE1vbiBTZXAgMTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBDcmFpZyBSaW5nZXIg PGNyYWlnQDJuZHF1YWRyYW50LmNvbT4KRGF0ZTogTW9uLCAyIE5vdiAyMDE1 IDA5OjU3OjAyICswODAwClN1YmplY3Q6IFtQQVRDSF0gTWVudGlvbiBsb2Nr IGxldmVsIG9mIFJFRlJFU0ggTUFURVJJQUxJWkVEIFZJRVcKCi0tLQogZG9j L3NyYy9zZ21sL212Y2Muc2dtbCB8IDMgKystCiAxIGZpbGUgY2hhbmdlZCwg MiBpbnNlcnRpb25zKCspLCAxIGRlbGV0aW9uKC0pCgpkaWZmIC0tZ2l0IGEv ZG9jL3NyYy9zZ21sL212Y2Muc2dtbCBiL2RvYy9zcmMvc2dtbC9tdmNjLnNn bWwKaW5kZXggNTEyODk4Mi4uMzk2YTViYSAxMDA2NDQKLS0tIGEvZG9jL3Ny Yy9zZ21sL212Y2Muc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvbXZjYy5zZ21s CkBAIC05OTAsNyArOTkwLDggQEAgRVJST1I6ICBjb3VsZCBub3Qgc2VyaWFs aXplIGFjY2VzcyBkdWUgdG8gcmVhZC93cml0ZSBkZXBlbmRlbmNpZXMgYW1v bmcgdHJhbnNhY3QKICAgICAgICAgPHBhcmE+CiAgICAgICAgICBBY3F1aXJl ZCBieSB0aGUgPGNvbW1hbmQ+RFJPUCBUQUJMRTwvPiwKICAgICAgICAgIDxj b21tYW5kPlRSVU5DQVRFPC9jb21tYW5kPiwgPGNvbW1hbmQ+UkVJTkRFWDwv Y29tbWFuZD4sCi0gICAgICAgICA8Y29tbWFuZD5DTFVTVEVSPC9jb21tYW5k PiwgYW5kIDxjb21tYW5kPlZBQ1VVTSBGVUxMPC9jb21tYW5kPgorICAgICAg ICAgPGNvbW1hbmQ+Q0xVU1RFUjwvY29tbWFuZD4sIDxjb21tYW5kPlZBQ1VV TSBGVUxMPC9jb21tYW5kPgorICAgICAgICAgYW5kIDxjb21tYW5kPlJFRlJF U0ggTUFURVJJQUxJWkVEIFZJRVc8L2NvbW1hbmQ+CiAgICAgICAgICBjb21t YW5kcy4gTWFueSBmb3JtcyBvZiA8Y29tbWFuZD5BTFRFUiBUQUJMRTwvPiBh bHNvIGFjcXVpcmUKICAgICAgICAgIGEgbG9jayBhdCB0aGlzIGxldmVsLiBU aGlzIGlzIGFsc28gdGhlIGRlZmF1bHQgbG9jayBtb2RlIGZvcgogICAgICAg ICAgPGNvbW1hbmQ+TE9DSyBUQUJMRTwvY29tbWFuZD4gc3RhdGVtZW50cyB0 aGF0IGRvIG5vdCBzcGVjaWZ5Ci0tIAoyLjEuMAoK --047d7b3a83aa57bc490523851de8 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs --047d7b3a83aa57bc490523851de8--