Create Extension search path - Mailing list pgsql-general

From Roger Niederland
Subject Create Extension search path
Date
Msg-id 4E835EBC.6050102@niederland.com
Whole thread Raw
Responses Re: Create Extension search path
Re: Create Extension search path
List pgsql-general
On my windows install of postgres 9.1.0.

I have a search_path set in the config file.  This search path has several schemas defined.
Some of the databases within postgres, do not have the schema specified on the search path defined within the database.

Trying to add pgcryto via:
CREATE EXTENSION pgcrypto;
or
CREATE EXTENSION pgcrypto SCHEMA public;
Fail with the error invalid value for parameter "search_path".

To add the extension required me to change the search_path.
Is it required that all any schema added to the search_path exist in all databases?

Thanks,
Roger


pgsql-general by date:

Previous
From: Adam Cornett
Date:
Subject: Re: : Looking for a PostgreSQL book
Next
From: Merlin Moncure
Date:
Subject: Re: Rules going away