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