Re: [GENERAL] Create Extension search path

2011-10-05 Thread Tom Lane
Roger Niederland ro...@niederland.com writes: 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

Re: [GENERAL] Create Extension search path

2011-09-29 Thread Richard Huxton
On 28/09/11 18:51, Roger Niederland wrote: 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? If set in the configuration file, yes (unless you want errors). You can set it per-database or per-user

[GENERAL] Create Extension search path

2011-09-28 Thread Roger Niederland
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