Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cggHQ-00073L-IK for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Feb 2017 23:25:04 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cggHP-000264-KG for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Feb 2017 23:25:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cggHO-00025x-Nh for pgsql-hackers@postgresql.org; Wed, 22 Feb 2017 23:25:02 +0000 Received: from mail-bl2nam02on0048.outbound.protection.outlook.com ([104.47.38.48] helo=NAM02-BL2-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cggHJ-0001BN-P2 for pgsql-hackers@postgresql.org; Wed, 22 Feb 2017 23:25:01 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=BlueTreble.onmicrosoft.com; s=selector1-bluetreble-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=xl6KMf14ltmlrOHo6HYqreKZ46qfrYwpefE3EAbLfaA=; b=iwHV8+TBstJtTZItFI8qEJVvdg/hC3YJ+BOgCf1Yl3YxqPx9z8T9chpUwop8zvXR8/x7ARrB8RnJEaFJDJecYdjjnoznESm7jH7f0aKDtNJpvfQzOrKzNk2tLdcfzp99b5e8pcv68pv9EESt1JhqL75Q4FxbpgP/e9eJgxIu5jE= Authentication-Results: postgresql.org; dkim=none (message not signed) header.d=none;postgresql.org; dmarc=none action=none header.from=BlueTreble.com; Received: from decina.local (70.113.18.142) by CY4PR11MB1637.namprd11.prod.outlook.com (10.172.71.13) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.919.13; Wed, 22 Feb 2017 23:24:52 +0000 Subject: Re: Change in "policy" on dump ordering? To: Peter Eisentraut , Pg Hackers References: <87866740-ef55-8a6d-6480-499b92aa23c0@BlueTreble.com> <8f64786e-824d-7c0d-33a6-3d9e1c8e9fde@2ndquadrant.com> <33b25c65-94f1-6ff6-c717-61a56294a255@2ndquadrant.com> <75409fb1-bd96-25c2-f6b0-c24e28ed2684@2ndquadrant.com> From: Jim Nasby Message-ID: <65049c27-96bf-317b-b435-931f6041f94c@BlueTreble.com> Date: Wed, 22 Feb 2017 17:24:49 -0600 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:45.0) Gecko/20100101 Thunderbird/45.7.1 MIME-Version: 1.0 In-Reply-To: <75409fb1-bd96-25c2-f6b0-c24e28ed2684@2ndquadrant.com> Content-Type: multipart/mixed; boundary="------------FD6DF0E1BE40ACBE0C73D7E6" X-Originating-IP: [70.113.18.142] X-ClientProxiedBy: DM5PR17CA0044.namprd17.prod.outlook.com (10.173.128.158) To CY4PR11MB1637.namprd11.prod.outlook.com (10.172.71.13) X-MS-Office365-Filtering-Correlation-Id: e1c1d914-cf01-488d-75bc-08d45b7a0141 X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001);SRVR:CY4PR11MB1637; X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;3:99WkfK0EtHjdrET5uPJUr1z6SDnqOwpQWtrNk0yjxxKMb5G2/wrUrmWoUBykkaIwD5HuU47TZp7uKLJSS7qxRnbUA8iUXTlOCF1ZC1q/+VDqwMvupvvRT5P5fEQ+ehcC90JF27CwZN6JICShaZIcgln/rr7dChYmbfO7Goo6zTe1lfYK3rLZ+oPKtAomwRCNNnfAjarplz/hZeoOFng75LQuhwBW+UgiaP1+zitDWYWxgYaW5CxuL92JTj1ig4L4gVXRpY7bC6GcV2SOhRoc4w==;25:Pz+Rrl3vl+wBCjWeSKCMh3q9OKfYtpJWJRXM7ccbwkfAo6LzHc9lj9q8B7lWsWGYAm7G/BllzPK7uIAB5lU+kTwcTcxYd3ZdDJhi9QR502v+DgDOE3i2619wrs4iSXk9vUaOlqKU5NWflctV2dnGe958XGOSqeSJrNNvxu90tCx9BC3lyMwKTfqBYVuERh4ioA7JfBBbqXgKCMxzZdiUh00ieeeBpIN+GtjMwn0FKzjtG41q8uBjPojg0wk/0JhjbeZ5eMecB2nzZyDS+Hn5TLt3AFAlOaVTeAkDxOIsgkQttL5ZdrfcO8BUTd8kZXvaw+3Kn5IRlf379GhgZE9p3fRF6h7isHPX2JpWxfO4h27Rs08Dwf/es7Qc9jI9GxuhviyeDaV3gyjBXt3Hin/IcIOvq/GzWaSJQ26tYWPl5gK8xHoHDDHWOygfe6xEupk15ZoqhI02LtAdAEBYg/q9RODZyeiBRvEvuN0VlkzTqrPAA50vCehPILb+7yer9bKe X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;31:H3DQmHlDsPSxygBYJ1wHBL6gm0n+HnEEv9lyKP+2yCkBwHLM8nxRoToHcyD95EG20CWkKaprlCvmUL30pHmqSznvm/JEtpKVIbKQwNbuwSOqvKDUKj735t1uitJD/1FWxfee21mdxEhtvkb2OGTmwUgsKrw4YTcQdKQqVI0H4JqrfWwyt6BoGrPEx3nIAE+zlxI96spYc/3Xq+Acvxp74Hkg99cyIXTbUwTZqExkGMCWS+wZtgR27fpn0lORN1Efq+ZFs8sx8m/t5uH1JZcy+T5qdyrglOCFqyFfA6d8GRJjt4ur5QI77gGlUG61Snsa X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(102415395)(6040375)(601004)(2401047)(8121501046)(5005006)(10201501046)(3002001)(6041248)(20161123562025)(20161123555025)(2016111802025)(20161123564025)(20161123560025)(20161123558025)(6072148)(6043046);SRVR:CY4PR11MB1637;BCL:0;PCL:0;RULEID:;SRVR:CY4PR11MB1637; X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;4:CFzoluQTl7eNXi/LNpEIY8ZV0ajR3ph4C6mPMArjHWXsmFGSAW1if2tfrpdm7gcu0zu1hImxMFBPLHP1WUJrRoT5quLOR7UTazLLAq0eXsvdu7kzXiLXvlYlh7T5Gc2nS4KxQxG4ujn1tGdp0cttMOk6TJ+nzXD29C3vG2pVy24oWxRFyTMyjZN9Y+0s5FAjxPEEwYVOlxR3fep6QqGr5bEEH8zEzOPQtoopAR9JTjsHc+HMzZmDZ865loTBZQSJOD7xONbVWqX130tB4O/ejxLNV/Kj8vRvj4lAX5V4AQQvKRZ2Bi6fvsATPHKWdK3BWdiCRoplHwdNhWYpk6ciN6QRDjE0Z4iHov9KMrxEYW/oMYhhLMkRTt7IFvookUnjNC9fi+Ie0q/f2ob7LD5tW3p62tZtFuTa6CPdXWyI5nUBNlKq112e3HkOGPyQTToTlPw/JE3cUjnIoZYjaW9aazH/bHflBx3+yf4s6J2vNAKhlcPMyazQN+PDHIDAXA20VHwSlGCwmiEOUwh8a5ZPYQRqKJmdAUmvW3TPdH9xQaJC9GoeTAT/nXWfwXH9jdJwaA/VC+xnGpDPVSDcOVd2hPFGPkUujp5lRKOQpsyfOpID/IK6pXGob+uaz5DXUsRQiqCrn6LiRF/CC+W3cq6oxeURW7yklxCZptIY+IPrERxB+KhlJrrST85SVrstLarR X-Forefront-PRVS: 022649CC2C X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(4630300001)(6009001)(7916002)(39450400003)(377454003)(24454002)(7736002)(81166006)(54356999)(50986999)(2906002)(76176999)(33646002)(8676002)(5890100001)(42186005)(53546006)(2476003)(31696002)(5000100001)(305945005)(4001350100001)(86362001)(512874002)(65826007)(229853002)(2950100002)(66066001)(64126003)(6486002)(92566002)(65956001)(3846002)(31686004)(65806001)(189998001)(6116002)(6666003)(270700001)(83506001)(25786008)(966004)(6512007)(5660300001)(568964002)(38730400002)(53936002)(53386004)(84326002)(6306002)(6246003)(36756003)(6506006)(93886004)(4610100001)(85282002);DIR:OUT;SFP:1101;SCL:1;SRVR:CY4PR11MB1637;H:decina.local;FPR:;SPF:None;MLV:nspm;PTR:InfoNoRecords;LANG:en; X-Microsoft-Exchange-Diagnostics: =?us-ascii?Q?1;CY4PR11MB1637;23:eFG6HwSGUVDSZqUOcXrgJnGz0EwLUw/qpNDfAGNxx?= =?us-ascii?Q?3Tvig9jITwqReD+U7FpLEzH1gl1+Cwzq8w6hqUpNGNj8+kY0J1yif/pBONUA?= =?us-ascii?Q?ViS6LMqAbaYS6RARWh9b2wCe3lIeN1RcEhtTpn77tcS7aK54HfCriT1TU+XG?= =?us-ascii?Q?3Ge4+LcsQaD3kJDivlW12QQicjjK3ryipkFMVyxdavvFQcOIOuUjarJEzlpo?= =?us-ascii?Q?dHTbZRmqhgiOtLPqIVJ+s5GFgpXyMyNH8p+IbG7H5EFLozTuFdN1esJQj96D?= =?us-ascii?Q?m8omZuky+Liq360LZldLHJaaAbJ1EiFiKHfBEhrqEpjgTdhvoA70iS7dmh3h?= =?us-ascii?Q?H0jGell4ga5CgEv3HBmzHnq42B62ZMqsKzSCVgziqA3hdDaMVM3Std+UuGRP?= =?us-ascii?Q?bFqdCzg460EAa9jguGjZIypdbCsw4TK8sTDdOn/0jg7RCC1NV3i9Ecz6gbra?= =?us-ascii?Q?69RGguEsmWtWrA6XZOQMNbM7+8SczOdI3fu0qTEyLe82zhichU2Ytco2ZUQu?= =?us-ascii?Q?3PoLEafXHfqYI38LjYnW8zFsSZ6ssLJCpDzK9/L3A4nZZyTV3bWJgZFGp45Q?= =?us-ascii?Q?Scjo38SqOy7YFO97o1FwxsFCHYePgud8OLePXno7IOzwXBt+IlU6Yo6vPrTE?= =?us-ascii?Q?AJ0uK03Orrk6tlmOc7tpf/Wpsvssd4iwxj8h6IUNgHsCRY/fhh9Cn5LbgEBT?= =?us-ascii?Q?/0xpr1WmiydYnEIpnNoA8gMTieyk06mhv0iuUlcgdxMT7tTAPI8JrbOJb7ea?= =?us-ascii?Q?aTOqxSDtm8zcIamDcQNvyTMc+c2l4lUr+gk5rGDJfuwnmc063XcNslEk0k7F?= =?us-ascii?Q?j4t1sUnP5feSufrLupuvp7j2Lb0olmCJklrYeV+asssK0ujgpqVyNIPBxe8z?= =?us-ascii?Q?i7uBSQdiNQs6foh+ZKRYGsTKfs8WChV8YwpxW6o1BHSwUpOvWVL7g3ttyJJr?= =?us-ascii?Q?Tpp3OXpv+OMhqg5dy6zyILsoc76PaHE1gCnjqEWBCWHNkCh426O36NKPeOgt?= =?us-ascii?Q?BDd3rH9rK3woqfZc7nxesnHPlDxYNpG840vvFgeAlGHmtR6bWLMqBTFsdtPu?= =?us-ascii?Q?b1qekzcAW8+RG5NeL8wOkhB1zGx/5DO4WRssLPgSrgxf/DxD0l597K6G6nFu?= =?us-ascii?Q?wrQfCzfBZ8pQZwKfRnkQbd6lwDHD6emCjglpsBQm1y8FlSOCZ2ALNUwUjXOa?= =?us-ascii?Q?kc5ow23A+P55NxN14V2mvsfZgHEbpdTd2PvPObS+8wW6a29GAfGD0j1JPcqt?= =?us-ascii?Q?u4gQACf09vHaPRzDiHIVBQ+m58ZJSTo97VADraWACLA3JQoPvvdJPkBd8cI2?= =?us-ascii?Q?vxIvhkBxTDibeqJVpmy9w9v1/BBalmzrn4eZ2nOMZFg5R2c+abA6yO6peNgt?= =?us-ascii?Q?/NkyA=3D=3D?= X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;6:djoYGZOnSpt5dg3K23Gtg7wqX3WPMEfh8RGlIUHlj6SASYR/4roQ21OqC6mLSfmIGcZHC3ETxUdU72EJkv2MWcokK5I2Lo3U/eFwyI4dku6uDXF7oSVmbv+uer6ohUcVeHmpKO8RBxyiPV979byf7bHhcjL0zYR8WX+kMMp/BkchstkyrFLQ/Rf4G4FpbD6SZJAm6cqXBCxGV0TBenvCVr+dwwH44RLh/0Pb7w+6Ls9claem811F6kBFmtpkhGaRPGPjoYaWnV6+qBLd/MPr7luE544ujPJyJPJZoovAT2Hq9d9LHuaH4eOsnGgf+MQv79wr6wVPrmYrOdX+VPjvHmqtclAPi6LgSqen9nCMTnnJQAQz3cAm40gq5pXFlAK79jrE280A2FFUdIBZaZCXaQ==;5:xb9Kd1udnsK+mkxg31+rEtkpk0YPOwQdjKrx3shOOqNAtD38INrQlpa1IWgn39836p5dmcaw8+Y2x0VrZ3jU6SuxlrJKd1pOzlEixMQDL2s+h06EITlwdeOkfyLwKxf18K9xYe4+kh9hxif8NdFcdA==;24:dC3uqgXppG4m40ghYAeODt5lzIkihAWbOrAOZ+KF9YzRqAoMEoTfsDxOuEnKjlw9K24XCNk9b/B2My5mL7zRISuCypOMFBk3t9lVV4kzRaQ= SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;7:TKh5ExI+vLrMCO3PCVSZN7vGA9/VetR9AMblMYPy/ESRMusz+nZvboiEog6K3Pzs+YxQI/pEK/SjZpxvQUsINPh5AXfgQMsNX1kXDQvfod9a2NDG6RLPVk9EOsJA6H7swY3e5y3GKn1qPDi8NeOkRqge0dxeCQRZq6772C03RusIFAYGEHqusvvCi3voblSghxSyGmPtJq2kgzNDKRS/obpC+ewkW+/qc4eAFrB6ws0Ov7JUMhomVF5pwtdS72rDMIW9HKplGCD+8GAd8WZsuTqOj/7UMAzkp1TMMdwWVb1yWTlqQtdqNyIpjFz0+7gQGarmyuTT0dcAwnVAYH4K6Q== X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 22 Feb 2017 23:24:52.8975 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: CY4PR11MB1637 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org --------------FD6DF0E1BE40ACBE0C73D7E6 Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit On 2/22/17 12:29 PM, Peter Eisentraut wrote: > On 2/22/17 10:14, Jim Nasby wrote: >> CREATE MATERIALIZED VIEW tmv AS SELECT * FROM pg_subscription; >> SELECT 0 >> >> IOW, you can create matviews that depend on any other >> table/view/matview, but right now if the matview includes certain items >> it will mysteriously end up empty post-restore. > > Yes, by that logic matview refresh should always be last. Patches for head attached. RLS was the first item added after DO_REFRESH_MATVIEW, which was added in 9.5. So if we want to treat this as a bug, they'd need to be patched as well, which is a simple matter of swapping 33 and 34. -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com 855-TREBLE2 (855-873-2532) --------------FD6DF0E1BE40ACBE0C73D7E6 Content-Type: text/plain; charset="UTF-8"; x-mac-type=0; x-mac-creator=0; name="fix_dump_ordering.patch" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="fix_dump_ordering.patch" ZGlmZiAtLWdpdCBhL3NyYy9iaW4vcGdfZHVtcC9wZ19kdW1wX3NvcnQuYyBi L3NyYy9iaW4vcGdfZHVtcC9wZ19kdW1wX3NvcnQuYwppbmRleCBlYTY0MzM5 N2JhLi43MDhhNDdmM2NiIDEwMDY0NAotLS0gYS9zcmMvYmluL3BnX2R1bXAv cGdfZHVtcF9zb3J0LmMKKysrIGIvc3JjL2Jpbi9wZ19kdW1wL3BnX2R1bXBf c29ydC5jCkBAIC0yNiw2ICsyNiw5IEBAIHN0YXRpYyBjb25zdCBjaGFyICpt b2R1bGVuYW1lID0gZ2V0dGV4dF9ub29wKCJzb3J0ZXIiKTsKICAqIFNvcnQg cHJpb3JpdHkgZm9yIGRhdGFiYXNlIG9iamVjdCB0eXBlcy4KICAqIE9iamVj dHMgYXJlIHNvcnRlZCBieSB0eXBlLCBhbmQgd2l0aGluIGEgdHlwZSBieSBu YW1lLgogICoKKyAqIEJlY2F1c2UgbWF0ZXJpYWxpemVkIHZpZXdzIGNhbiBw b3RlbnRpYWxseSByZWZlcmVuY2Ugc3lzdGVtIHZpZXdzLAorICogRE9fUkVG UkVTSF9NQVRWSUVXIHNob3VsZCBhbHdheXMgYmUgdGhlIGxhc3QgdGhpbmcg b24gdGhlIGxpc3QuCisgKgogICogTk9URTogb2JqZWN0LXR5cGUgcHJpb3Jp dGllcyBtdXN0IG1hdGNoIHRoZSBzZWN0aW9uIGFzc2lnbm1lbnRzIG1hZGUg aW4KICAqIHBnX2R1bXAuYzsgdGhhdCBpcywgUFJFX0RBVEEgb2JqZWN0cyBt dXN0IHNvcnQgYmVmb3JlIERPX1BSRV9EQVRBX0JPVU5EQVJZLAogICogUE9T VF9EQVRBIG9iamVjdHMgbXVzdCBzb3J0IGFmdGVyIERPX1BPU1RfREFUQV9C T1VOREFSWSwgYW5kIERBVEEgb2JqZWN0cwpAQCAtNzAsMTEgKzczLDExIEBA IHN0YXRpYyBjb25zdCBpbnQgZGJPYmplY3RUeXBlUHJpb3JpdHlbXSA9CiAJ MjIsCQkJCQkJCS8qIERPX1BSRV9EQVRBX0JPVU5EQVJZICovCiAJMjYsCQkJ CQkJCS8qIERPX1BPU1RfREFUQV9CT1VOREFSWSAqLwogCTMzLAkJCQkJCQkv KiBET19FVkVOVF9UUklHR0VSICovCi0JMzQsCQkJCQkJCS8qIERPX1JFRlJF U0hfTUFUVklFVyAqLwotCTM1LAkJCQkJCQkvKiBET19QT0xJQ1kgKi8KLQkz NiwJCQkJCQkJLyogRE9fUFVCTElDQVRJT04gKi8KLQkzNywJCQkJCQkJLyog RE9fUFVCTElDQVRJT05fUkVMICovCi0JMzgJCQkJCQkJLyogRE9fU1VCU0NS SVBUSU9OICovCisJMzgsCQkJCQkJCS8qIERPX1JFRlJFU0hfTUFUVklFVyAq LworCTM0LAkJCQkJCQkvKiBET19QT0xJQ1kgKi8KKwkzNSwJCQkJCQkJLyog RE9fUFVCTElDQVRJT04gKi8KKwkzNiwJCQkJCQkJLyogRE9fUFVCTElDQVRJ T05fUkVMICovCisJMzcJCQkJCQkJLyogRE9fU1VCU0NSSVBUSU9OICovCiB9 OwogCiBzdGF0aWMgRHVtcElkIHByZURhdGFCb3VuZElkOwo= --------------FD6DF0E1BE40ACBE0C73D7E6 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers --------------FD6DF0E1BE40ACBE0C73D7E6--