[postgis-devel] Tested postgis_restore.pl

dustymugs dustymugs at gmail.com
Wed Dec 28 13:29:16 PST 2011


On 12/28/2011 01:04 PM, 'Sandro Santilli' wrote:
> On Wed, Dec 28, 2011 at 11:06:28AM -0800, Bborie Park wrote:
>> Hey strk,
>>
>> I've tested the postgis_restore.pl script on one of my databases.
>> All my databases are structured as...
>>
>> DATABASE
>>    contrib (schema for postgresql contrib modules)
>>    postgis (schema for PostGIS)
>>    userland (schema for user content)
>>    ...
>
> Interesting setup.
>
>> The default search_path is: userland, postgis, contrib
>>
>> On the whole, the script works.  But I'm finding that two PostGIS
>> 1.5 functions are getting through to the userland schema.
>
> Only _after_ the call to postgis_restore.pl ?

Correct.

> I guess the only way to do that would be dropping the
> 'SET search_path' produced by pg_restore, right ?
>

For my setup, I have to alter the search_path to include the other two 
schemas.

-bborie



More information about the postgis-devel mailing list