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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers