]> git.evergreen-ils.org Git - Evergreen.git/commit
Set default db schema search path to public,pg_catalog
authordbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 16 Mar 2011 04:03:54 +0000 (04:03 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 16 Mar 2011 04:03:54 +0000 (04:03 +0000)
commitda06561edb028359a38d4763d5cfd1f5e1116682
tree4157a44421b1bc3d20cf0bbf7d45a12dbd0682ce
parent74053bfaa8739f27e1f7b6e44e927fe588d7d330
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_1@19760 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