]> git.evergreen-ils.org Git - Evergreen.git/commit
Clean up build errors when creating/recreating database schema
authordbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Sat, 12 Mar 2011 23:37:45 +0000 (23:37 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Sat, 12 Mar 2011 23:37:45 +0000 (23:37 +0000)
commitf48a41b861100e2d5e1d4669b7c4d540530fe284
treecca722bb0859a0ac8d119460ce7fbc0031235c79
parent61ac85fe7cc9a5e0b75bb6a0f65c73aef743faa9
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?

Use IF EXISTS when dropping the unapi schema to avoid an error.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@19723 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/000.english.pg84.fts-config.sql
Open-ILS/src/sql/Pg/000.english.pg90.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/990.schema.unapi.sql
Open-ILS/src/sql/Pg/build-db.sh