Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aakVO-0006j0-46 for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Mar 2016 13:38:26 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aakVN-0003pt-EQ for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Mar 2016 13:38:25 +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 1aakU0-0002Jj-UW for pgsql-hackers@postgresql.org; Tue, 01 Mar 2016 13:37:01 +0000 Received: from mail-bl2on0060.outbound.protection.outlook.com ([65.55.169.60] helo=na01-bl2-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 1aakTs-0002t8-P9 for pgsql-hackers@postgresql.org; Tue, 01 Mar 2016 13:36:59 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=BlueTreble.onmicrosoft.com; s=selector1-bluetreble-com; h=From:To:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=rPWgOLxfvEqLZeegUGRXJCzUS3xQ2ES7+uL3YJ0iciQ=; b=Zg7xB0KAYSnfjUkG76lX+XMSJE+h6ht1E+LXR0MwzChlsF8nqPMAF/G3ZbiQdsM0WvmLMBl3I7vMC2MLLx8x4ZEC+VjKQMenCn3T1eEHPFPAi7bpEDwkacXg2saKp5QidmO8Qn3VXAX0yhxFXIbJ9sV/eBbKx55XbXSjpacuT9E= 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 (108.232.179.70) by BY2PR11MB0677.namprd11.prod.outlook.com (10.163.111.19) with Microsoft SMTP Server (TLS) id 15.1.415.20; Tue, 1 Mar 2016 13:36:49 +0000 Subject: Re: dealing with extension dependencies that aren't quite 'e' To: Abhijit Menon-Sen References: <18108.1452869354@sss.pgh.pa.us> <20160115170826.GA28307@toroid.org> <20160116144818.GA17401@toroid.org> <58C7A345-193B-4813-A7AA-4B78358313D6@gmail.com> <20160118053819.GA18576@toroid.org> <20160301012745.GA11489@toroid.org> <56D4F6B7.8010200@BlueTreble.com> <20160301043320.GA13286@toroid.org> CC: From: Jim Nasby Message-ID: <56D59AED.8080300@BlueTreble.com> Date: Tue, 1 Mar 2016 07:36:45 -0600 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:38.0) Gecko/20100101 Thunderbird/38.6.0 MIME-Version: 1.0 In-Reply-To: <20160301043320.GA13286@toroid.org> Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [108.232.179.70] X-ClientProxiedBy: BY1PR0501CA0005.namprd05.prod.outlook.com (25.162.139.15) To BY2PR11MB0677.namprd11.prod.outlook.com (25.163.111.19) X-Microsoft-Exchange-Diagnostics: 1;BY2PR11MB0677;2:ysbjZX3JIo4168AB/xEVwUhPo35qh4qoQRBA2rk2WgaiiA8v6M9jZrTfsIUdeZsBr6PHBONkeeDhDElYq5G+R2x+tauuvbYwVmLuh3zU6zNuBT+UXBE3voBsPd1e50yocXeGF9Mavfg9dU6qKtpc7g==;3:ugz1Ajzv9/yBxHHexV4TIgNNJlEqHMrLU+HMIbEEfEj2ak/1vb8Xcg+hrFbTdRNndRHLN6yxL15Ao7eB72u89asb7UdBimQ2/M3yfFmkgrV/qg20Q9fPckIW/qQX01CJ;25:NMy9keqmVBH1RP2QedBud+5Zu4PygTBoToeA8eiGKQMxSGWCERIeIgk0e1qSQUgx5WP2M7K97bjFknAY2gAuT2ullMbcm56PPJPtY/2cbuQINAytTnIlSosOTM1m6Y0VgbCoRNcN9mw+dtssHMFiYsoQVPc1LrC++oOTZIeb7GGE60gWbviI5kEBgxiaQ41gn15vo4SpS65lhcFKVMPI3Q/idhHYZS+9C9LI5UZ5gvcPWfloeUDYUj0Ujx4UMWoC8XmuWZuVl2XyIscxa4qnMX+aExzkxtWcbM7bGF3YgHSx14fzikOR6rDlkeWwB2tq2b6wymRdU64cX3TgLkr2Zw== X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:BY2PR11MB0677; X-MS-Office365-Filtering-Correlation-Id: 4c850a7c-b3ad-4141-af60-08d341d68aee X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(601004)(2401047)(5005006)(8121501046)(10201501046)(3002001);SRVR:BY2PR11MB0677;BCL:0;PCL:0;RULEID:;SRVR:BY2PR11MB0677; X-Microsoft-Exchange-Diagnostics: 1;BY2PR11MB0677;4:UohB88uZeCbks16sRR14nB/mWyru4RmDStoTiP4xvfRawfdlpUDyaMtBigvVkTXs5+XlhDhQe+6LxcKC4n7B1zV0UJB4xTRaqwopfX17noRMVpOrd0E6o0UfR44fDTlxgMTdAm4e4oMGybkGcDr1MQkiEMaYehtNLYgXeI+lJuD8m2Qhw8QiuEwZ9HEPosI7K3eOr8HclA6otJcGEo4StnYmGYJkX/v4WDL9ru78aZk37ApNSuN5yEKh+fK8OHAkHN/VjVaneyFmZa280a38BDrwkcuCNt+ecJPymLxhIwDIp+rbm+falnkmPveg1NptRh7q0VuAmYIyFe+aL7VniXE16nklN3CywtYaERVv487uVnzzOyqQ0TDwVBbRImP3 X-Forefront-PRVS: 086831DFB4 X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(4630300001)(6009001)(479174004)(377454003)(24454002)(47776003)(87976001)(66066001)(65806001)(92566002)(86362001)(64126003)(76176999)(81156008)(50466002)(4001350100001)(23676002)(50986999)(65816999)(54356999)(33656002)(6116002)(189998001)(87266999)(42186005)(3846002)(36756003)(15975445007)(93886004)(2950100001)(5004730100002)(586003)(77096005)(83506001)(4326007)(110136002)(5008740100001)(230700001)(122386002)(2906002)(19580395003)(1096002)(5001960100003)(40100003)(85282002)(336755003)(18886065003);DIR:OUT;SFP:1101;SCL:1;SRVR:BY2PR11MB0677;H:decina.local;FPR:;SPF:None;MLV:sfv;LANG:en; X-Microsoft-Exchange-Diagnostics: =?utf-8?B?MTtCWTJQUjExTUIwNjc3OzIzOlNKd01SYUJhekNQNFBDOWVTbERjUmZxbTRH?= =?utf-8?B?Wko2dHdUNTRLb2NWL2lpV0NhcitHY2NqSDdVb1p3TmRsaStXMlNPVTlmbkpO?= =?utf-8?B?dld4Sk12Mnd3YmtGVjFtNXhXdllxN05NUWJqdDhvU2d5SDRWMElqS3krc0NU?= =?utf-8?B?MXZxcU91ckZpTDZBZG9TSkZCczJxS3U1SDl4UGFtK0k1dkhNMDM3VjBEOG1u?= =?utf-8?B?dHUvOUl1L1V6bVRxV1BzZDJJSlh2Q3l1N3pqaEFuSzQraEorbThsSUk5bEd5?= =?utf-8?B?QWZ0Rmp6bFlGRm1UOVdCeHUxQm5la3pSYkQ1eGZnS3R1RWFRbVU5Yzg4WGRQ?= =?utf-8?B?MFpwS080dnFxSWhoeE15b3BZZVpkOGZLQS9HNTlIYW5nbEZtQ1g2c1dyVWtK?= =?utf-8?B?ZzlLTWZnWk04dWJnb242U3dtWTVsTkgvd0RYdlRFVmVoUnlUcnVydk00QkxZ?= =?utf-8?B?MHBlMDdldkZPVTIwMnphcUdRcENXRnhVQkNOOHdJNElXcnB3RUh3TVpoaWE5?= =?utf-8?B?UVNVNzlPdnROTHNGS2JQYnFkbml3VFBsblhubS84UW1YZ0RUZWVlSDh6d2xq?= =?utf-8?B?ZGs1TXdGSlFEekNPWGptWnYzTGxwVmcvYmEzRklSbDBSMUgvM3BpZTcyUllu?= =?utf-8?B?NG5rVHQ0L055aHRPL3d0bklGUS9SZXJzbHRXWW1RQ1hPeTlRUW0wK3pRaGN6?= =?utf-8?B?WkdMZ1FMamE4clBMbXN0aXgzMjRpNGJmOHJqc3Zxb2tkZGtYeDJhMVpPYnhX?= =?utf-8?B?bEt2Rmw1UDdpQTdGRjB1WnN4cUtGdXlZZUl3MFdTdU92cEpiS1hud2FBbW5Q?= =?utf-8?B?WmJrVEtYSGZCL2tvMjl3cXlGZFZBTzVOb2tZQXg2MzlTc043UjlhUVYzL2hs?= =?utf-8?B?MUE4V0dxOGVVQnpqWkY3Wk9DUElRaGhTMmU3b2M4Z3ZCUWo3V2FwWng4V2Ur?= =?utf-8?B?bEpRRlp2cXBIeVAyMVpLdXJNTVFSU3BPTVZ6RDBtRFRSL1hoOGtqQUpITjNo?= =?utf-8?B?UFZuQVlQTlBrczE2OUlJaExONTJzay9HYkFmcTg3NG5oaGRCOEw0MmZ1MS9W?= =?utf-8?B?N3hMQW9VQXBkeFc2SXpiVGt2NEVuUU95WkhaWitEczJPYllEOERIWHdHWDht?= =?utf-8?B?d29BSk1ZMVN4RFBBMFhMQTNuUkZ4TjlubUJsMEIzRGZaUFFPamc0SE5JR3l3?= =?utf-8?B?NHcyWFNOc005ek1IQXJnckNIWnYwVkM4MXcvV2szM0RONjVodG5Bcmw4OE9D?= =?utf-8?B?QkRSWDZXRFNnYlZhOUdiTHVhdVFqc2NJRmRDOFUzaGNYcjhOTVBwQkg0NWNN?= =?utf-8?B?UmFGdTZwU2dyOEZjd2ZOclg5NEJ4NFVyNEdqRVc2bEZSYkxDdUtRaFhGM1Zi?= =?utf-8?B?c3M2b1g2bGp2OHYrYnBBMFVpRVZ3Y1JFY1BwbG96WSthaElneGhQSmZsMlp6?= =?utf-8?B?bm1UdUpCdnplYmcxUVl5eW9Sek9Ya2U4YzMybDh1U0xJM3YrRWR1UWUvWGVY?= =?utf-8?B?UW9BemJEY1BVUnpZR08ycThUb0EyYUoxTTZvS3czV2tGMGlYY1FsdVVtcTZE?= =?utf-8?B?QlUzKys3VnVDQVcraWdMVDAvekJ3SWUzQWlpaE1EN3p1cEZ4d2hZWWtwQk1U?= =?utf-8?B?Rlh2TFBISXdYeUhoSmZkdnBjMlAyRG1ScmI3K3FPL1E5VDljMG9SZGEzZjV3?= =?utf-8?Q?T1JGlkN0uCLTv81M/0=3D?= X-Microsoft-Exchange-Diagnostics: 1;BY2PR11MB0677;5:YcVPLdisi2eZwJE2CQNlPq9EqxzrA5//6ll4D6/F2G0Bp4Fl2J3BYR68dZI3ptdhNOiIM6eW+CqyK2x3eBV9NEqA0Njwuh7c25jM0+0gCTRCHQKLGYGpPZltHvnd1tC8xR6qKccUrcZQyPOHLmCopw==;24:hRNeBEQkiEizntPz0WHG11dy+yaGx3yz8JnsiQp69J2IgL5tNeFYkQBMXSIWdYP8pzLIW1NXb4a7jt/kZ8iPDV1F7fqHuMrOdKbuNcpUz2I= SpamDiagnosticOutput: 1:23 SpamDiagnosticMetadata: NSPM X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 01 Mar 2016 13:36:49.5795 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: BY2PR11MB0677 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 2/29/16 10:33 PM, Abhijit Menon-Sen wrote: >> >Given the audience for this, I think it'd probably be OK to just >> >provide a function that does this, instead of DDL. > That seems like a promising idea. Can you suggest some possible usage? pg_extension_dependency( regextension, any ) where "any" would be all the other reg* types. That should be a lot less work to code up than messing with the grammar. -- 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