Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cgYdd-0004WT-He for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Feb 2017 15:15:29 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cgYdd-0001Vx-4Q for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Feb 2017 15:15:29 +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_2) (envelope-from ) id 1cgYdb-0001Q3-Hp for pgsql-hackers@postgresql.org; Wed, 22 Feb 2017 15:15:27 +0000 Received: from mail-by2nam03on0086.outbound.protection.outlook.com ([104.47.42.86] helo=NAM03-BY2-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cgYdY-0007wi-GI for pgsql-hackers@postgresql.org; Wed, 22 Feb 2017 15:15:26 +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=FTxdTC07p94zHO/fgl4bPPvDvQj6n2LMMuUrLHXxDmk=; b=TWhCMRYz9NwJ8RusyywtW/PhlkYN+6Q94YhZEyuq4ERM0QKxLz+dcMwPDHt0aHZeACxh/tzdTMji8H3hBrbZdfnjE3FBa/mUsBwGW/wlmZApqk8yj/sjQgAxNdpFEzIMDV2zVjdg7bFd5WzSLgdrWCuU3hfQmZk8rzmYSeTWUTc= Authentication-Results: spf=none (sender IP is ) smtp.mailfrom=Jim.Nasby@bluetreble.com; Received: from decina.attlocal.net (2602:306:ce8b:3460:e483:b2e7:fa67:d256) by MWHPR11MB1646.namprd11.prod.outlook.com (10.172.55.11) 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 15:15:19 +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> From: Jim Nasby Message-ID: Date: Wed, 22 Feb 2017 09:14:56 -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: <33b25c65-94f1-6ff6-c717-61a56294a255@2ndquadrant.com> Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [2602:306:ce8b:3460:e483:b2e7:fa67:d256] X-ClientProxiedBy: DM5PR21CA0036.namprd21.prod.outlook.com (10.172.92.150) To MWHPR11MB1646.namprd11.prod.outlook.com (10.172.55.11) X-MS-Office365-Filtering-Correlation-Id: 27a1825e-dcbd-47eb-a363-08d45b359e24 X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001);SRVR:MWHPR11MB1646; X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1646;3:Drg7LmeKsS0m77rjBTvqQo3Xz3qzMxxaZ/AliKeMjeyhrG//dly41MY64OJHXD1YZfFhKho4Cpsm2QHys2Sip3fKJ4Ah9i9r8SeWSme5d7BW0rg6CZPf+j8h40txVM+gut2/jot5G3viKAP5Z1zgz8ZeYGORxv/bm6FuDks3k6xaRAhHxUu1gLOJ8IRNlEYDy/l/VS2tjJbNA4+Y9dL+eufpn/4MI3O7COT9hWqi3HBXmU3YodJcV55Z66Efz+ry7yNaP7eUKAflfJZ1/81cUw==;25:GtumosL2d9qWLaI/qhNDXsH7lFZK/Lc2f9P4ccljW+4M7nnrd+PLGIMS12gjOxFFfOeg10elgcAf1G2XQOjg9immpzNe0MkJ3qjkGiPcSgTeC6lM6hvExexSXCgrjLKUquH30gq7dHWhikw20sk0S1WwUGkBvvszy4rVzIp1n+esXwrFFlYoDX/QEQZ2WZRIP5446IFqJ8QD5fgxZYUi5G2A+cfBXu8Z9R70xmt9XjqqalXMfdlqB3vp8saqP2e80Oo+bTjonFM4SwyyvcU60+TVOSaRUbY0oXQ4t3xCwpXVPVlSg6QdqqocGAMw4BB6S6U4uY4vEMaFT0lztjbbazmsSk5OkST2vemMUfIj9BwLe0UhcYmoxSrZ2w57DcTq5ouZGjFUJHqSiLx/dzHE/hVuELJ8Bc1tPk+ADQctfxsc36Mgx8kqUt1Zzr51nvRiCh8ahKJUSf8zi3fHTZlJpQ== X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1646;31:C4pqIO7BL9Si3OHPeM7xK2a0gjxxvOlfekC+Gy7A/ov1zNFJONpxMrf/K7N5QQ7klt0POrKs9CiP7ZpD3Ea2RSDhzd2ThST6Eh4ikcML2oKnqiyl3wq4ViA8k+m78G88p4TMMKbDEj7fNqmd02RLqriFi4cOjCWH6bfDb9p5gy84BOa1rJQ8V8wzOyddeYsLW2r5B45CFrsfLJtdS3Kivj+UDP2SsKMCFxx4iMdQTDuVHQa45Wg13yHN/zXlkrJD+tjdCM9ymY5IVIeZK3xQyw== X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:(35073007944872); X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(6040375)(601004)(2401047)(8121501046)(5005006)(3002001)(10201501046)(6041248)(20161123555025)(20161123562025)(20161123564025)(20161123560025)(20161123558025)(2016111802025)(6072148)(6043046)(6042181);SRVR:MWHPR11MB1646;BCL:0;PCL:0;RULEID:;SRVR:MWHPR11MB1646; X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1646;4:nJPqFMEGt5CEP38fKmiJwUiWLaNHNZ7sDwn9pf5qpS00Ynre96ixfEbRiQhBdpO9ZoZ+mBFLcNgSlCSvgafJxNvVT2WWg9XpDVpghT8VwJoIBHFOp8hsPM4EHoo3/XABLMazBlK23a0RZ/WgQJO0zniCGmgFUniKR9SlJI75WmWi+qBJ0rTWpkZuh7D3tub8rgd+bdmf5LjYY7xXTme6BSTj7wfz28kAsao4ndm3rQ053v2zopJi2yC4MZAs1gnYY9yiQeQlUybePNo5CBjNnkBZfOROxZ5QkrR4ae8zmWI0285AQm69Fhzu7PUU4/jNwrwg88Vk2lO8qZk9BD9JuX+Q+Yy0+GpjgTkGSIhbFqwT294Qi72OnEoDstDRzgLIcKRxmJOXCxJlKrxpciwc3WIDysqtofQLpKlg0VdFQOmEtXuu07UiYe7ZF96tJhdibTGIZMvKPSwkHLwOFeyxtD/7npCQ/Yw2v07n8UhxPMnjkcv/UT8etd7S/ecS0n2jiOGiV1LPBdc+EWHiMKO0uNv9kSNgVf9Iizxob0LeO0xFwO8EwepACx1WFkpD8vsEr4OMKnLKZ8O2skev6bdSBiLyqFTS/Os/E8TZVbHRsYzDjliBG4pcr6HcqkWoucnYyrfxFJw5IWAGhCm05Y770T0m7QfYmk+bCqjf5vmzLz03l6kvheaD10PdIiGJktqiLw50sAWT8KbqHLNGASU6w9vmOEMIzFCRw8xKBXhJsc8= X-Forefront-PRVS: 022649CC2C X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(4630300001)(6009001)(7916002)(189002)(199003)(377454003)(24454002)(38730400002)(53416004)(83506001)(53386004)(6512007)(5660300001)(105586002)(6306002)(42186005)(6246003)(69596002)(229853002)(93886004)(7736002)(47776003)(65806001)(305945005)(64126003)(25786008)(53546006)(65956001)(81156014)(54356999)(6506006)(4001350100001)(6666003)(86362001)(31686004)(53936002)(106356001)(230700001)(76176999)(36756003)(65826007)(97736004)(31696002)(8676002)(81166006)(6486002)(23676002)(68736007)(2950100002)(92566002)(33646002)(50466002)(6116002)(101416001)(189998001)(966004)(2906002)(50986999)(85282002);DIR:OUT;SFP:1101;SCL:1;SRVR:MWHPR11MB1646;H:decina.attlocal.net;FPR:;SPF:None;PTR:InfoNoRecords;MX:1;A:1;LANG:en; Received-SPF: None (protection.outlook.com: bluetreble.com does not designate permitted sender hosts) X-Microsoft-Exchange-Diagnostics: =?utf-8?B?MTtNV0hQUjExTUIxNjQ2OzIzOmtLdG9FanYxd044NERHL3ZJUVhaZ01COUdj?= =?utf-8?B?NXRhTlZNSGo3MUxZZzFtUFFlRlJqM1ZpSmhlVFNjWWg3d1E2blBhY3FHYXV5?= =?utf-8?B?RnUrT0xMbk9GVC9aMEpITTU5RkdDelcvMmM1YUtNWnhwVkJyRDRlanUrQkRU?= =?utf-8?B?REFUdjZqbm1EQ1JiajlUWkNVanlmZGc5a1hDUVVNcjVGSXN3RTJSVlZQdERj?= =?utf-8?B?SEc2ZlUycFpJc0VSeDNaZXNOWmRsSTVMTXVTbm1WL2dKZmc0aW1iWW9BbVZv?= =?utf-8?B?NFM2ZlNoZG5hcWM5ejlrdUp2YVFhc2d6a1RiYjBxWlZHRUJ5K3JDbE9Ycm1z?= =?utf-8?B?Wkd3QnhuZDg1czI4Tm1wcVJZdWg1bDBCcFZFT2llQ0JJSkxjNjIzUHU5bnhC?= =?utf-8?B?bVp0WXg3aThIakZLakdvLzlvMnYxR2FCVlo3clZSbkxkMG8rQUdoUVo4Ry9k?= =?utf-8?B?UWk0ZFloc3Jna2RVVE1aMWFmcXVyUDNBZy9NTGhjM2xEVTZEQjVoUURiMHY3?= =?utf-8?B?OXFhSlFOQmwxS2VlZm9yRU5UMWg5UWU2YXlSU041M2liZ21wYWRSanlpVnFh?= =?utf-8?B?THFhRmVCVjFNTldZRlRQbzNmMm42V2dPakpuZmxBYzVaZ0QxK21jaW1Od3Iw?= =?utf-8?B?c1dFVWFkaHBNM1d4VTJMUU4wYlhPZW52c1pkSmJ4OXNtQXVnSnd6WUtLUVdN?= =?utf-8?B?WlZIaWR4UVJmK2VMalJaYTVyaEdySzc5OVBwVjREL25vbXpOOWtuQ05CLzJj?= =?utf-8?B?YW5YaCt6N1dQOXZJQW04YkxpNk9UUmVBUE1YRXBsZ0c1Q1U1VVpmaW9wQU1P?= =?utf-8?B?STJnM09XY0tGUlZmdU1mbUcyc08ybHdyYnhhclZES3h5aEtLUytXUjc5M0lP?= =?utf-8?B?VWltTTFBMUlrbEloSVp0VVJhMkxCL1p0YUNjVk5PenY0emlZTXkrK1Y0bjB6?= =?utf-8?B?Zy9TUzNWMGVzVGRNNWswbUpWUzNlekx2VjMyY0E3NUk1MjRlWkpuYyswTTdx?= =?utf-8?B?N1lJNjYzMnJuM29XZUEybXl6VmR4ZldweURlVW9Od21DaHUzdUM5UHU5RmdM?= =?utf-8?B?Qk53alZ6ckY4Q3cyT29JRGJzbTVkU0FTSGpUeXRiRHNsTVhFY1o1NWxDa2Rx?= =?utf-8?B?V0xSNUo2eWJLK3M2bGxqeVF4UXdtK0dncGZ6dzgzL09TbFFwdWlna1ZEMHRz?= =?utf-8?B?VWUzM2toSGRDR3F3N0JKY1Zva3VsNzFOZWYwWDM3WG8vZXFFVUpRYmIrUk1B?= =?utf-8?B?SVZtNlZPd1VJZUNHTjMxbHkvaFlxTlJRNDNJWm9UVWNCaTd2M3VWWEtiQjVD?= =?utf-8?B?SHdyTG5pYmtNNU9hOUJ5RFkrQkRqYVF3RjNSaFpCaS80ZW92YkZ3NlJDb0Fu?= =?utf-8?B?SWJoWmFrbnRmbXljQXlpb21vVzRDM0ZoSFFQRzc1Mm52d09lMkZCVFBqajRE?= =?utf-8?B?R1hDejFSQ1VDaldFZW1ldHl3ZnFqYVV2MVhyOUZaVjhmdS9XV09PMnYybHI3?= =?utf-8?B?Vk41dFcyYkdlM2NpYlRjZDVUaklIeVYvQW5WZE1NVHZFanZiMEY0SzZCYldV?= =?utf-8?B?MlRjNnhtMG9nSWlmU2hyalN0OE9sSkxFVVJydk9kQWxiajNCSnREZ3RNOERH?= =?utf-8?B?Zi9kUFYwV3I5QS8wb2RjSXhpWFVCSitpcTVaMnlVTmw0VDhtMkRCcFNic2t4?= =?utf-8?B?ZkJ2TjJ0MFdQVWxMZHJsek1jY3ZvcUJDRGE1WU5STUkwbXA1YUZOcUIzMkZQ?= =?utf-8?B?ckV0djlOOXlsbEYyRS9lTU9YNTlvUFRrdXo5U2YvMVRWcmN1clRlVVNrcmZH?= =?utf-8?B?RDVVNG9CSUhDeUZ3RXFMVU5laHVkd2JPckxjbVNFZFhEQ0FpM01ndDEwcE9l?= =?utf-8?Q?gSYmfVsW55z0TfljFuJWdTeLw18AHYc8?= X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1646;6:QXm6iia3F84l0BH/WtxN/HtaskQwa+gAmFLpUvwr+upsaB1ro9tPUWKLem9/gdbobmUhtHn63d/KZKevwz7VJMTHe3PvGj9ZTwAAN9GZlsIyLZFXRg+NmYjnuKoO35AGNWiMv6CMEWk3vP8RrHC9uz47YZFhQGDkfMfSLbxSf/WXOsYw4RcPCuPqvQyaI1BfqU9Tr3lPJhbycZwqoOmq9TJJLXjsCvXTrgjdHvZn/kuCX1mhAoIdQw3I3nKfj5gvpdb8KuMLlCcOGkftPdocwIVoyn8VYhE/DB6SZyWBKAAq/a9uZ/1smtX7P7fujI8tzGfdjsG+A2Nhe+fcxMSK4aJ+/3n3v2lG1+DJsh9OOzqBIPgNnvN43+e/hFgDE5artji4Lj0x5mNq0ty80oqytA==;5:fN3bMrsqOrecRKuRhGG5FgLlDZrAtYCMZk8A8VQF0VidmyW5Wn0sLp8bUad8eVJrbPxd7nu0TZV3Ek4PO7XV6dXBJek+DG0Wp76gHIM02ayH2JHC+FfitThyAhZ19mRI1E+azKff18nS2oLQcT8R7oCPs8aw5A2OB1RWUSALQQY=;24:eC4x+07HM7SFdjBZ9ccHK8YXboWXPxUq8nRStUM4F7DOwevLnYaNb7JLDMtGOoiixPjN78ACrFyHeeGXLX/q61LRt8/6mavoMuKygoNZzDw= SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1646;7:wh8gcU4o/Kndy/p/NCnPKuHMvcpuhMMlgLVeKoseUtEwO7lptGZE9qlXfAsjH2foo7t3KBfZcVJBe502tkKk36nnMfrUH32M56L8to+iwMBweLKFUhr14H+VByQ50km7gWpGPQrkb9UKt3SeBBN29hFwpdUeFKfSYzzXvyEvDDGdqqkm7nee3RxPe41ImsKulsYn9MRSBL8+WEUJfLA8d9vwo6+d61bb5WrKdtfaqkG5KrisyWtvY68FtHSCPf9oNqB2qsv1Kzy8BUwUMSFRlM/PDykghe+0nGBBv/ijlRJU6Yef6UUvX73/7gx86l+atRBpoqxXK+6mQoOHLJoyQA== X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 22 Feb 2017 15:15:19.4854 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: MWHPR11MB1646 X-Pg-Spam-Score: -2.3 (--) 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 On 2/22/17 8:00 AM, Peter Eisentraut wrote: >> Actually, I think matviews really need to be the absolute last thing. >> What if you had a matview that referenced publications or subscriptions? >> I'm guessing that would be broken right now. > I'm not sure what you have in mind here. Publications and subscriptions > don't interact with materialized views, so the relative order doesn't > really matter. 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. -- 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) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers