Clean up build errors when creating/recreating database schema
authordbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Sat, 12 Mar 2011 23:14:20 +0000 (23:14 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Sat, 12 Mar 2011 23:14:20 +0000 (23:14 +0000)
commit26dceca40755be225d927f12bf6fa45d7b86a8b8
tree37aeb3cc6850cea818c1584d2800abca65577c79
parent869835987171863ca0be36c45ee3afbcb2c8c5a6
Clean up build errors when creating/recreating database schema

Dropping the evergreen schema cascaded and wiped out some previously
defined functions, so move it ahead of the other functions. (And maybe
we can start moving those public functions into the evergreen schema?)

DROP AGGREGATE IF EXISTS exists on any version of PostgreSQL that we
care about for Evergreen 2.0, so we can use it to avoid false errors
during schema creation.

FTS config was complaining about public.english_nostop in the ALTER
statement, so remove the schema qualification. This seems to have
been there for a long time?

git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_2_0@19721 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/000.english.pg84.fts-config.sql
Open-ILS/src/sql/Pg/002.functions.aggregate.sql
Open-ILS/src/sql/Pg/002.functions.general.sql
Open-ILS/src/sql/Pg/build-db.sh