In article <200911300708.12397.akla...@comcast.net>, Adrian Klaver <akla...@comcast.net> writes:
> From a quick look it would seem the easiest solution would be to change the > search_path in: > citext.sql.in > uuid-ossp.sql.in > These files are found in the respective contrib directories. Uninstall the > modules. Rerun make and then reinstall. FWIW: I also manage some databases needing one or more contrib/pgfoundry modules. By habit, I install each module in its own schema (with read access to everybody and write access to nobody) - this helps to distinguish between your own DDL and the DDL of helper modules. For example: CREATE SCHEMA prefix; SET search_path = mymodule; \i path_to/mymodule.sql ALTER DATABASE mydb SET search_path = public, mymodule; The SQL files of a few modules mess with the search_path themselves; this can be fixed by editing a copy of <module>.sql and \inserting the copy. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
