Re: Review: Extensions Patch
David Wheeler <david@kineticode.com>
From: Kineticode Billing <david@kineticode.com>
To: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Robert Haas <robertmhaas@gmail.com>, PostgreSQL-development Hackers <pgsql-hackers@postgresql.org>
Date: 2010-12-08T20:21:31Z
Lists: pgsql-hackers
On Dec 8, 2010, at 12:18 PM, Dimitri Fontaine wrote: >> It's certainly true that a large fraction of contrib modules should be >> relocatable in that sense, because they just contain C functions that >> aren't going to care. > > As they all currently are using the SET search_path TO public; trick, I > think they are all relocatable as is and all I need is to remove that > line (and add the property to the control file). +1 This alone would be a huge improvement, solving my complaint about @extschema@ for the vast majority of cases. It's reasonable to make the author of a multi-schema extension or an extension that cannot be moved do more work. Best, David