Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1a019m-0006rC-EP for pgsql-hackers@arkaria.postgresql.org; Sat, 21 Nov 2015 05:56:18 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1a019m-0008L5-0x for pgsql-hackers@arkaria.postgresql.org; Sat, 21 Nov 2015 05:56:18 +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 1a018Q-0005wM-0T for pgsql-hackers@postgresql.org; Sat, 21 Nov 2015 05:54:54 +0000 Received: from mail-bn1on0064.outbound.protection.outlook.com ([157.56.110.64] helo=na01-bn1-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1a018M-0007iY-P4 for pgsql-hackers@postgresql.org; Sat, 21 Nov 2015 05:54:52 +0000 Authentication-Results: spf=none (sender IP is ) smtp.mailfrom=Jim.Nasby@bluetreble.com; Received: from decina.attlocal.net (2602:306:ce8b:3460:6cc0:ba90:b1e8:f37) by SN1PR11MB0688.namprd11.prod.outlook.com (10.163.207.146) with Microsoft SMTP Server (TLS) id 15.1.331.20; Sat, 21 Nov 2015 05:54:47 +0000 Subject: Re: GIN pending list clean up exposure to SQL To: Jaime Casanova , Alvaro Herrera References: <20151119155222.GJ614468@alvherre.pgsql> <20151119161846.GK614468@alvherre.pgsql> CC: Jeff Janes , pgsql-hackers From: Jim Nasby Message-ID: <5650071F.6090002@BlueTreble.com> Date: Fri, 20 Nov 2015 23:54:39 -0600 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:38.0) Gecko/20100101 Thunderbird/38.3.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [2602:306:ce8b:3460:6cc0:ba90:b1e8:f37] X-ClientProxiedBy: CO2PR06CA036.namprd06.prod.outlook.com (10.141.242.36) To SN1PR11MB0688.namprd11.prod.outlook.com (25.163.207.146) X-Microsoft-Exchange-Diagnostics: 1; SN1PR11MB0688; 2:ZAPTD92W7t7iW9qa+11W7EJKvHHC8SIELNDcWOEGPpTiO6CXjwXIqYL4qmww2tPhGlHawLRvciZaSw/aecedejE2HjAwgNa8xzsQckYvqPmwZvbhXt2c8wF0sYa2mn2NWiVWgYbZM5u7UqOgOylt+A==; 3:ea0Ta3Ts/hO8ooGz9NhQu9N86Ryt9OBEx+tu0MQtvgnK1PmZYIyB9rlv9VChPF8J8Sg/fxUguRb4N/k/kKUfNCLMolRe1XpGfJ37wysz2D4tjzZucahHL3ZR5gHDafao; 25:Lsci1PxdF0mwHfrdY6alWKyCyYApz3AuuMcTRavwgJ7pVPRzZ1KTYISP3nsDDmBYqMzlPSVx8dbAeosj6cvZivXhRO3YbItXLmLxWR4lb10a1QRnLPK+dDgoGCdnHbal6q/LVnG6A+FNc5dlI8iNFCEi8aAn6p9a2pheggA7DP448yXkZ12jUkeqGR5HtdrO9sb4riMHCPyjqnrDeFZAfX+S3BPMTVc46e7OonASZvQhuC/4sG9/bAC5A9TCF4BGg3Fan8E02wbQKniVpeATEw==; 20:WO9JmqziVoT5w6iKg9ueO/V7vK0HIbFtdt0YCO3yraa8l5ibMe89ZUYAGoKdQAPphxKeTBjf+DNqZKafsvvbK8tKRF8Gi+SekRNuObvOIDK0tAofMktSv0qP0BpiAThWHB/fztwuOA+pW+V0oCjljfrBc/CP2LYgGh+JSxomFXM= X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:SN1PR11MB0688; X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0; PCL:0; RULEID:(601004)(2401047)(5005006)(520078)(8121501046)(10201501046)(3002001); SRVR:SN1PR11MB0688; BCL:0; PCL:0; RULEID:; SRVR:SN1PR11MB0688; X-Microsoft-Exchange-Diagnostics: 1; SN1PR11MB0688; 4:WWSJ5PggHjaVK1Gu+oD8N2UcqaWopNF0UoUJjIEto2mv7+jKlVXGg8Qv7ZqyyI5beU/cEdtteEir96JISCDF04mVo5krhTBmvTC9OFiWmxVgrc7gC6/AvHsxCnLm0uf/Zda3NLN/PQUUUCoD+uAhK0+WkVh7Q7tXL+kugqK0uXfLrZZgVNv31BIOqb6DzWNu4g+vllXOcmvABZooYa0yFKvnYbZCDPpAHhts+PhFRPwMP2t9q/YhwYWn409vO8gIh/vzGAxX6fQ2r9lsibv+x7NEMF2E2x2xeBAWn8N4/yjVChZ4hzTeVxco0N+4cUA/o+y4l2txB2Cief+V3EBFLukvXFA9wG94z0Yvv7bqmQx/1/X6+UJw8jF3Vn/TAGeI X-Forefront-PRVS: 076777155F X-Forefront-Antispam-Report: SFV:NSPM; SFS:(10009020)(6009001)(189002)(199003)(24454002)(479174004)(377454003)(15975445007)(53416004)(59896002)(2950100001)(65956001)(65806001)(6116002)(23676002)(50466002)(50986999)(5007970100001)(105586002)(33656002)(5008740100001)(93886004)(92566002)(36756003)(4001350100001)(54356999)(77096005)(106356001)(5004730100002)(99136001)(69596002)(80316001)(87266999)(101416001)(5001920100001)(42186005)(86362001)(76176999)(97736004)(122386002)(5001960100002)(189998001)(83506001)(40100003)(47776003)(5001770100001)(64126003)(87976001)(230700001)(19580395003)(81156007)(586003)(65816999)(3826002)(85282002)(336755003)(18886065003); DIR:OUT; SFP:1101; SCL:1; SRVR:SN1PR11MB0688; 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?MTtTTjFQUjExTUIwNjg4OzIzOlM0aW5SRCtsTjJ6azlDN1N3M1hWZVhaRUZv?= =?utf-8?B?Kzk4T25YUWR4VXRvamR3RWMxOEsxYjBDc2Q4aVJLWTM5cGJiekxCMnVsZjdN?= =?utf-8?B?dU9pbjdWL2hodTcxV0pNRVhXNTAvakk2cG16OHVTdllJbXB6bldMdnRRd2c3?= =?utf-8?B?MmtPK2FxUFJpbkJ5WTdTWk5vWFc2YnVCS01Cdk0zY1hpSEx3eUxyMlBaaVJE?= =?utf-8?B?V0ZkZjJabS9ENzYwaWtuUE5GS1ZxZE9TcmFFRkR1TDY1WUwvMnc5UGU5TkNJ?= =?utf-8?B?V2w5S09WQmVCMXVxWm1rcUZBTzA2OC9STHpBOTBPeVFpVkM3YytDdEUwdVBM?= =?utf-8?B?N0ttM3FmNkJPZklxaHV6S2QraGVwdCtxRjB4Qm9uZ1NYbkx4bjd6bUtVTndo?= =?utf-8?B?b2ZxZ2VqVThTQWtPNTZxeWx3ckcvdjFJSytlVHhIV3k2Y1VWQzdORkY4UUtE?= =?utf-8?B?OTFMMWZnaTZtMXVjd1Iwbzd0NXVCU1ExbXdXdFdZUW1Ed0txOVZ4Y0xlUTgz?= =?utf-8?B?WmluODA4WDVCTVhGbE5pWmxRWlYxME41amFqaTlHek9mT3lCUHd2Y0UzWE5n?= =?utf-8?B?bXNCeXI5ckpGQzhidmNkN1dxRndROFM2TUNLNk44b0U0a2creFZyT0MyWmNN?= =?utf-8?B?M0V2ajNaNHAyNFRWeWdjOC9JRVl5ZzZjaEFYeFhRdFU4dzloNE1ZMXRQcWZU?= =?utf-8?B?K3VaNG1qalNXRk5MUDNpRTk4Q3IvUUN6OWNuaGVWRlVJMlhiNnVIR1VYMGht?= =?utf-8?B?NGJ2bE9xY1ZydlNIMmdjbmF5b2ExRWczcGo4TWgvSmNDa0VteHpqeTkwcjcr?= =?utf-8?B?WU55VzJVVU1SUWE1RSt2enhxV29jR3dLamtUZi9IeUQ4VEIwMTYzbmdMUzBK?= =?utf-8?B?UEFDdHdMNHR2ZkxuWEZ6NVFDZ0tZenFCRHo5eHI4U3JSTUtPeUUxYUZzTm02?= =?utf-8?B?QTZXWllvZERSVTFicUJjTzJ5OGVxUmo0dXV2VzlhOWh5K1Z0UkJGamFSbFR3?= =?utf-8?B?V05PemdBV0lZaW9FS2tDamRFZ2h6R3A3ZVNYV3V4VFFPa1l4U2xQVG1FZldR?= =?utf-8?B?SXMwTFJvR0VCK2RNSnh6VC9ZN05MdWN0UWl3QU1kYlBEQ3VyeG1qSnBJM3Ft?= =?utf-8?B?Qkd6aEZFWEtoZHYwVkFFMW12UEhCY1FUNmRqWU1ieEZ0L09SNVBBTDZYdkps?= =?utf-8?B?dU1ZWFM4UG1wSnNhaG51WU5SQlBCeG1Da1lYOXFidDkrRmtQbnFHTFYxaGJZ?= =?utf-8?B?RldWV01oOGRjK2JkWGEvVUc4MEkzRm1wOEpvMFZWbVZYT3lBRG1FblU5OFhI?= =?utf-8?B?TmtZVTk5QzRwSWlEaDdxMUxhamhmaFpQblRId1FISFlSakM3OFV3eENlNFlV?= =?utf-8?B?eVlyMFd2T2lrSys5aHlEQTMxWE5RRWs5VG9PRUxnZmlaRkY3NFRTeVBhZXEr?= =?utf-8?B?RVdpMWR2dklCazdOY3RYYmJ0NFhkc0FTNXgyL25UUkwwYmp3QkJvZnVRNzRT?= =?utf-8?B?MW1BY0NtdWpXZHN6Q0RxWGdhK00zZktvL1NhNXdlOXkzMGR5WTY3Nm5zVDJo?= =?utf-8?B?UHRhcVh6MXcySG84NVk4OEhta1pXUnpaTmtGZ1hRaGVUaHFTdzh2WHpqQlAx?= =?utf-8?B?ck9hTVovUnVpUmdoSEwxNWJ3dXRscFAzRFVoYnpmS2lNWERXdzJmT2tkNHQx?= =?utf-8?B?QllBaVpLZjhqdWhBRTBOTU5Jb1QyeStmeDF6WVZibEhDamxUQ1hwY3UzZnd6?= =?utf-8?B?eGFNek50N3RVakdwOG1QcEI2NUFNaDFkZSs2SDdtb2gxdk1OTEtuVm9uajdG?= =?utf-8?B?WGw5VmJqOFN3Y3FzUHorTXdGM0tEbitmSVBBay9qT200ODJCVG4zMGRjdG9W?= =?utf-8?B?SlB2UWg0RDc1MXNHc2Z6dExmakR0SjFGSmFObXRWMzYyb3lWbjJ1c2dLcjAr?= =?utf-8?B?Qmx5UVZVZVdhSzB0MGtNTnhJc05BVDBwLzF0bm0zNmxWMmJnc3MyWDRsc3dw?= =?utf-8?Q?TJViH0?= X-Microsoft-Exchange-Diagnostics: 1; SN1PR11MB0688; 5:kwu7ELyznDpQpNh57ERSeBX/7cvZjn9fKr/bWaqwQUmF7SPpQ/KI9pddDkKCd64y0jQRzDWnF4fEQGurGSVzyCft6BeBSRIKmtqShvwUpF2JkLoPX83tUtqXAdTpiNACyyWC5VmjtzxLKvJMwK1xZg==; 24:Uaeblb7IpNkB+6Cb0NY/sR10yoR/TkvjfJByKN/AKPr4vbTqLzWBLZXhefy3AUVquM1Y+neK3nN5ajFo3TEz7zSixrIeFiVtZrEwIvg04XQ= SpamDiagnosticOutput: 1:23 SpamDiagnosticMetadata: NSPM X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 21 Nov 2015 05:54:47.1639 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: SN1PR11MB0688 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 On 11/19/15 10:47 AM, Jaime Casanova wrote: > - only superusers? I would think the owner of the table (index?) should also be able to run this. -- 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers