]> git.evergreen-ils.org Git - working/Evergreen.git/commit
Set default db schema search path to public,pg_catalog
authordbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 16 Mar 2011 03:46:43 +0000 (03:46 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 16 Mar 2011 03:46:43 +0000 (03:46 +0000)
commitce5e6d8f7b58683b493e8a6326186f914bc45151
tree14fcd1256d98124833bafeed0b6078341c6c5f9a
parent5e43a00948a7650ea7d16b9772f90aa81dc5078a
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/trunk@19759 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