Set default db schema search path to public,pg_catalog
authordbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 16 Mar 2011 04:04:19 +0000 (04:04 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 16 Mar 2011 04:04:19 +0000 (04:04 +0000)
commit94eeb1a141e6d415e05550ac7d8359d5f838a3ca
tree22e8f71cbac0b4dc8d818f68f99e6c74ff0df5ee
parent845055f3405ab94a6c509f6909f9f2b26e9369e1
Set default db schema search path to public,pg_catalog

With the addition of the 'evergreen' schema, we discovered that
all of the unqualified database objects were being created in
the 'evergreen' schema if the database user name was 'evergreen'
(as the default search path is "$user",public we started matching
"$user").

Thomas Berezansky proposed a variation of the function provided
here for changing database settings. By creating the function in
the first schema file, the subsequent connections pick up the
new default search path and all works blissfully as it once did.

Long term, we should probably move towards explicitly qualified
database objects.

git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_2_0@19761 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/000.functions.general.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/002.functions.general.sql [deleted file]
Open-ILS/src/sql/Pg/build-db.sh