Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cgGbs-00007z-W1 for pgsql-hackers@arkaria.postgresql.org; Tue, 21 Feb 2017 20:00: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 1cgGbs-0008Mk-9I for pgsql-hackers@arkaria.postgresql.org; Tue, 21 Feb 2017 20:00:28 +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 1cgGaR-0006eq-FJ for pgsql-hackers@postgresql.org; Tue, 21 Feb 2017 19:58:59 +0000 Received: from mail-bn3nam01on0055.outbound.protection.outlook.com ([104.47.33.55] helo=NAM01-BN3-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 1cgGaO-0006Vs-0t for pgsql-hackers@postgresql.org; Tue, 21 Feb 2017 19:58:58 +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=4jklONolst8adcmH3iT2zfW1HN4u0U2yuBvptYfsZtQ=; b=WjS55t9bA17ZmTI0Ghi9JcCtDo4JzcJNSYQyzZ2hjpNswi+jbHExhwuBOamv0qsuv3H4xGWEGqggJ3adwzla0Upo1I1Ai7j7CI/8xI+6vVdvotC/ehfoXM0LmrQ6TvXZVmJ50JV/0t/5ZDglSBivVEzj+8gS7Zl/StS3Y/sdmEY= Authentication-Results: spf=none (sender IP is ) smtp.mailfrom=Jim.Nasby@bluetreble.com; Received: from [192.168.1.158] (70.113.81.123) by MWHPR11MB1645.namprd11.prod.outlook.com (10.172.55.10) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.919.13; Tue, 21 Feb 2017 19:58:52 +0000 To: Pg Hackers From: Jim Nasby Subject: Change in "policy" on dump ordering? Message-ID: <87866740-ef55-8a6d-6480-499b92aa23c0@BlueTreble.com> Date: Tue, 21 Feb 2017 13:58:48 -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 Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [70.113.81.123] X-ClientProxiedBy: DM5PR18CA0046.namprd18.prod.outlook.com (10.173.208.32) To MWHPR11MB1645.namprd11.prod.outlook.com (10.172.55.10) X-MS-Office365-Filtering-Correlation-Id: b1719a42-8410-4c9e-c0b2-08d45a940f84 X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001);SRVR:MWHPR11MB1645; X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1645;3:Nku2+q6oL1cdwoCWsxb1K3cVpGLQjIzgcHORi41oGIrfKk+bBmKwFOI92WATijVcZBjxuhIpVNSVVDMYa8K22agVa2JeCEZsBip6Olwldi4e63d2VjcBMsT7gXU+PllTYNKLySbPW5Xy4ModN2L+A4WLxBQt6hcH0iSpGtVRRfKjGB+z1NtCGjA6Ght06tOslACU2ZcSOTOhWAdmcwWngY771U+hpSpY0CfjNevH2Z+BTGaQtux0pQZWONY6Lz85iqZV4lPT1tjZqaVlLLj/7g==;25:PsWLQdc79tBEmor0+2t7hpyuVoHu0q6dyhceCdZbXWO8bjNA7IHAuBtgbtBxCjqQWQMaArqljGiQLiXdhs2on1WzHMnvXsZPctgLAmCbFI0rHfXJAdectCV82YDJ5xijyPeBzXq/Q/QQMU6UGLCIWnl0jnFmQXZ8y4kikNeJeH39zl9DSuSe8IxtPjYSEhAD4TXyE5KJKq4vVzzIygceCAlFQ+HvNiKegdBIr5Sz2+bX/ehjm8iuP9zCLHBPIcnt80ZHasWZWQDd19c9fNIXVxkvhqqKCHY+7GclN50wkR9QWI1GRdHUlAnFoqp/uXYYEF91NSss4PVgbmMRVrC5U9CSCiXv/XsWw7oQAOYsriK93hOa9Yfup7Erj1P+JSJePw5pKc2kDMPZwFuX+yGyVeZ4zy7e+ukafCpthEgyN0MbPvXRBOCyWAf2jt3RbTVPluNtP6+1FFQu/AQOGIU62A== X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1645;31:b/MVHe/SrzlOdiAIr+JVvaeDCYQUCW2Jjh8tx9aSWwB3vZOWZLoU55W0ixH85uVSodxbuGH/wAHQOSI1I42dbk8n19LzSmmxQzH/QNRZmTdPU9/ys91XpyGh4l29qrjdZS2iy7BRhrrboAv4N/JnpB6Fo9d3go/PseHNwxwGVBhQVl+7fI/iHb/F7hV+sI90NfFDC4YbZkp9y7unU/ljY09OBEOebfNXaeQss8MFqckmPGuODHvdFZY6Sk/9R7W89p52Z90owGS58PVx0KCOd6h+Dja56IqT5YFnHSVBjrY= X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(6040375)(601004)(2401047)(8121501046)(5005006)(3002001)(10201501046)(6041248)(20161123560025)(20161123558025)(20161123564025)(20161123562025)(20161123555025)(2016111802025)(6043046)(6072148);SRVR:MWHPR11MB1645;BCL:0;PCL:0;RULEID:;SRVR:MWHPR11MB1645; X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1645;4:DwCVPRVz4yOB+4q1jjSBu8inYOD5Bd0bqFWiu+GZ7CVlZMhA1SB/7uH4mCYTYQWQ/P164KPNo2LQLr4nIJcIHUQidr4DoV+4Wp4mUEOUzjqZvE1ZzzmsNBU7pbVjD3LHTGI/aBnN+B6+wxGHVnKM221w3qZlH66v/OCnsmOv2Dsj0hyVDJNEwUO5Faq4UiPACMCm4vAvCUrDSdwlQEFRFiukCVdPCa7dQEY4vBuiTUCdt4S4GGzsCfITpZQJEsbZJjCmYzvLwZVr7YTI7mYjEf7YopQnuaHWOVGqjpvhAFplb82nOm+M2Ri3zuMDrTBnYydqpL/HjUGK4a29tPMLJxEAps2RZgYxSZyj46M2RZCsvqomaOWgMnq/zTKhFT3/s4/H9gDlL2hf7QEECJ9byLXy1wqlzlG+VJGWZiyhBkxv8N6eUG13ekdVDTEqz9lkU7XweUlXbG2djNEnLbCts/p6v2PdpaiPW7LwSQuBeKcqlFk2z5kATNKm3Lc1jndCSZiCk12Pgn5Mt0cIGxumfSnyXKiZcpsBoPwviOzEarF7l8pXLnpo1Ku6rStjMOr5FtptuxfnLji4CjBlQmLNXKBK41aGXhLFw5mVMdUNJkza/Sqt6G+2n1lhFJi8tEum/k6F+LumHL7zptsp7CRHqaVhrIK683muCsxvF40vKxA= X-Forefront-PRVS: 0225B0D5BC X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(4630300001)(6009001)(6049001)(7916002)(39450400003)(39410400002)(39830400002)(199003)(189002)(31696002)(6306002)(31686004)(64126003)(90366009)(6486002)(77096006)(42186005)(5660300001)(2906002)(50466002)(106356001)(25786008)(105586002)(36756003)(86362001)(6666003)(450100001)(6916009)(83506001)(33646002)(110136004)(101416001)(66066001)(50986999)(6116002)(47776003)(65956001)(305945005)(3846002)(230700001)(38730400002)(7736002)(65826007)(54356999)(65806001)(92566002)(23676002)(4001350100001)(81166006)(8676002)(97736004)(53386004)(117156001)(53936002)(966004)(81156014)(189998001)(68736007)(85282002);DIR:OUT;SFP:1101;SCL:1;SRVR:MWHPR11MB1645;H:[192.168.1.158];FPR:;SPF:None;PTR:InfoNoRecords;A:1;MX:1;LANG:en; Received-SPF: None (protection.outlook.com: bluetreble.com does not designate permitted sender hosts) X-Microsoft-Exchange-Diagnostics: =?utf-8?B?MTtNV0hQUjExTUIxNjQ1OzIzOm1DcUlBVE1nbk1XcS9hVmFLcVJvQWc5VU93?= =?utf-8?B?RHpMMXkrM1cvcWcrbGJCblBmRlFmTm54alZ0S3EvdWVINFhXOUYwN1RIT1ZS?= =?utf-8?B?eGczcW5UYWhqaUlJampmeEw3RXJENURNdjdVK0ZJMEhNZWVDRjBLd08wc1BM?= =?utf-8?B?WEI5bmRaTGk3S0NId3FHR0tRZHNhV1lHU0ZLWnpyTW13b3IwWFZYUVNFeWFE?= =?utf-8?B?emZ5dURzdFF5b09WTUdwaHRzVnRnc0JGaG50Y3Q1VklQSnUrOVhlYlBWa2NV?= =?utf-8?B?RExyWDh2UlNiRVJYWXBHaUswQk1ob21ZWXE0UHF3dzM0VXdKYzM1aFpkK3Qw?= =?utf-8?B?VmI2MjlxeXVYM3VwVmdZdFFQVGZ4VTVnRHJQZWZwaWdTY1htd3ZEQ2FPOG05?= =?utf-8?B?SlpBc1NKaXFBQzhBdTdmeGdwS1lLY3VqS2ljYTFWQy9hM3g4dEkxbnpOMS9H?= =?utf-8?B?cGdsZkF1VTEwK3RRSFBoZkI4M2t6Ni9aeUpUa0N1cUxFVnkra2Mzbm9RUmdz?= =?utf-8?B?VG0xRHByU2hZN042aHlZWGxieWp6OHAyN0tBMVMvdE1hcVlNMm0vQ0pYOStt?= =?utf-8?B?QlV1c0EwNC9mbU9PYWFJWEszTnd1TUZqanFvZmhsKzRSem9BbjFzbVA1bWda?= =?utf-8?B?eTRjZWhMR3UwWTdtNk1qS0tnNWZJUlM3VlBoVTY4OTdMbWhkYy9hcUFRd2JQ?= =?utf-8?B?bWJHTG03OW4rLzQ5Ulo5cFQvYmtCMHh4VjBBQTROeURTTHkvL2E4TG9YblZ6?= =?utf-8?B?eWthamt2UVc5Q1M1V1dTZWZHcmJ4cjdHOERQVG9HZ2RZK0hXd0p3VHhJOVdY?= =?utf-8?B?VDFGUjVkamVBVTlUbk52cFMwZTZSUC9HWExwZXNuK3lyMFd0YXIxSmppeWFt?= =?utf-8?B?YlFlOTdaWGhMOG1BcjIxOEd2L3NabFVsK3RpWW0xeFRLaTMwa0Z0eVl0N1Vo?= =?utf-8?B?cXJpNXR2RDJYUDFheFJSQ0djLzE0VW56YWlORThycnVQa2w5eTRJZTNIbWZr?= =?utf-8?B?TGhCNWg4dG5zdXJKcitSOUg1Vzc1bFNpeUFGN1d1bVpXOWJ0S09YT05tQUhJ?= =?utf-8?B?bXhDWkdKT3B0T2NkVHI3NUYxRGFJZ0dwTVRNdVpONnh6Q1I5bEJUUXJEV1FY?= =?utf-8?B?QWIwZ1ZiTW8rNy9IZ2h6dTdVcHVadjhVN0ZoUE91V3ozeGN3WkJxdWw3K0dp?= =?utf-8?B?WmdIRnhXM0JmcFlJYmlxbk5yZWJJRWVjenk1NDVZQituOXhaSGdDWit2bnYv?= =?utf-8?B?OTZwL0JTczdUMmdnR0xlbXo5WlpoZExJNURjdUk0MUJoSi9sRW8vNm8zWGNw?= =?utf-8?B?Ui85OENPRWdjOXhsdXRnZEFFNDNQa3hqN2hPb0RPYVhYbXV5UXJRMVlSbGFT?= =?utf-8?B?NWx1M0M5WlVUcHJMSHRqR2hYMXpkSldqTmZtNHNLakJqQTBUWFFDeFRITzhw?= =?utf-8?B?WWFMTEJhV0VtV21RejBmdnY3QUFwRnp4U0NPakUvY2U0SnJUYk1CMHBIRWla?= =?utf-8?B?c0ZXeHB2aVkya2cwWi9jTUJodHFPWXRyMUJjeWYya1JuTk5MMS93WjVCcVln?= =?utf-8?B?WFpJMk1YL1VlbXNxblBiclRZRHdvYTU4S0lYRDFsZ085K0cvTWtCbzN6WGpV?= =?utf-8?B?MllUdTF6cUNXaFA3eHFTb3NCbytSME1RNmhnM213UExDN3FLR0k5RWdtL1hy?= =?utf-8?B?bjV3QVhqUTBUWGQySjUvMXFLcFNPNTFUV3FXaFhzRnVUL0JuYmVGN0QwNjhG?= =?utf-8?B?L3l3bVJRbTVhR0llRFRIelhyUzFQNXEvTEc0Tkt3R1dhWVRjbko0WCtlNVda?= =?utf-8?B?dFhwcDdyMzNjNEJkRXVxU3B4MHJRenhWZFhDbmJScFdYYUgyUWVkRE5oQWRn?= =?utf-8?Q?xvmd/1J0XEgRHsVIpw7+fMdHvnYaahuu?= X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1645;6:bD/3mxq3VkKrZskHUWy0Jcks7mfwDLvRBL3rSwIhzSAHA+CvnOXxB7z0qlepEstw+/kFKJW5ZXdqtTRNV4QPiCuWOTKLZ2uKRWLaqvwalo53oFffg8IRBh4I2Y2+M7wAUsMX0OlBfX8+W1ZksIOvl+qm8xDdtNz/QhdlpR7/o0mBfETJyAT+ap6bf4vUMYRN+zPAtizppaUHATF5em4iI8NqjtKUKlaAiyz1aaQNqiDxtR23NkBHKsALDU9w3VXcqZwbCIAGqNEo5j/RsOHScW0u7PqYV4Lyw9j9OFb15vVMA2212fw5Ns5TM93c1bKt9fsBuvmZeSC0PxvgwOfdacX0yZYVJNa7lHdSDfS0kRf5DkOrb5FG4GUUn8SFruNmIVeh+CMazTVsapIoXgMPwg==;5:5m1F0LKADPsmLVIv780BjStq4oGwv9ZfaNwQ3bpDM60xMiZY3gcHE2TwhLsAAt/QZe4mM9xAuw4pAzCgiXexJf6ipUW7E8HL3QgnV+2lwNNeHB/gvdYEMDKGPs50HzyN6C/jc/WVduVueL58HQH8pW1NnmegoTYxWf7HLhk0w6g=;24:YCh0xvs3AxWNzcWF9DFfLOY//8woofh76ZB957aP4+RlqcZK9taxWzODCvo1sT9mntAEqwhm14EHQef7YnVe3ig6JLZvHwxxN9lha2ta3q0= SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1645;7:BTaApmOdXRsbWfbA2UoXLhUl1iARhcJnm1CxpbY20W7h4Redma1usJa0CAJ9I6O0d3JAfxeFZ43nCGdZHpaOcjB0LdnUAexzg6fmBHR1bso63R0SuVRTTsRVpseNI4RPrgoBoRdL7V4GtK8RWzWFIrMqHZR3W9aLIlPmrC0eZSQ8NBr/2hFImS1KjcMtM6xCTeIkfGaj6DZJdBQd2dbPJcbOCTUVe497HC27upXJKRqTr8X0SKphkOS5lgg6MSwIbxGunympqQlgmUxFRb7Bf4KubIxB04vTCoY1ir6OP7Phkj3odcg78RWVN7yCynvygqI6Bg/D7iRKLuvCU+D9fA== X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 21 Feb 2017 19:58:52.5818 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: MWHPR11MB1645 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 AFAICT in older versions only object types that absolutely had to wait for DO_POST_DATA_BOUNDARY would do so. More recently though, objects are being added after that (presumably because it's easier than renumbering everything in dbObjectTypePriority). Is this change a good or bad idea? Should there be an official guide for where new things go? -- 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