[OPEN-ILS-DEV] psql:030.schema.metabib.sql:24: ERROR: function oils_tsearch2() does not exist

[Don McMorris]

I'm helping Grace install Evergreen, and determined that there was a
problem with the database.
<!--
Welcome to psql 8.1.8, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

demo-dev=# \d
            List of relations
 Schema |     Name     | Type  |  Owner
--------+--------------+-------+----------
 public | pg_ts_cfg    | table | postgres
 public | pg_ts_cfgmap | table | postgres
 public | pg_ts_dict   | table | postgres
 public | pg_ts_parser | table | postgres
(4 rows)

demo-dev=#
-->

So I tried running the "./build-db.sh 127.0.0.1 5432 demo-dev postgres
[snip]" from /Development/ILS/Open-ILS/src/sql/Pg

The error:
<!--
Password:
psql:030.schema.metabib.sql:1: ERROR:  schema "metabib" does not exist
BEGIN
CREATE SCHEMA
psql:030.schema.metabib.sql:11: NOTICE:  CREATE TABLE will create
implicit sequence "metarecord_id_seq" for serial column
"metarecord.id"
psql:030.schema.metabib.sql:11: NOTICE:  CREATE TABLE / PRIMARY KEY
will create implicit index "metarecord_pkey" for table "metarecord"
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:030.schema.metabib.sql:21: NOTICE:  CREATE TABLE will create
implicit sequence "title_field_entry_id_seq" for serial column
"title_field_entry.id"
psql:030.schema.metabib.sql:21: NOTICE:  CREATE TABLE / PRIMARY KEY
will create implicit index "title_field_entry_pkey" for table
"title_field_entry"
CREATE TABLE
psql:030.schema.metabib.sql:24: ERROR:  function oils_tsearch2() does not exist
psql:030.schema.metabib.sql:26: ERROR:  current transaction is
aborted, commands ignored until end of transaction block
psql:030.schema.metabib.sql:35: ERROR:  current transaction is
aborted, commands ignored until end of transaction block
psql:030.schema.metabib.sql:38: ERROR:  current transaction is
aborted, commands ignored until end of transaction block
psql:030.schema.metabib.sql:40: ERROR:  current transaction is
aborted, commands ignored until end of transaction block
(continues)
ROLLBACK
-->

I tried reinserting tsearch2:
<!--
template1=# \i /usr/share/postgresql/8.1/contrib/tsearch2.sql
SET
BEGIN
psql:/usr/share/postgresql/8.1/contrib/tsearch2.sql:13: ERROR:
relation "pg_ts_dict" already exists
psql:/usr/share/postgresql/8.1/contrib/tsearch2.sql:20: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/share/postgresql/8.1/contrib/tsearch2.sql:26: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/share/postgresql/8.1/contrib/tsearch2.sql:32: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
(continues)
ROLLBACK
-->

Postgres version:
template1=# select version();
                                                    version
---------------------------------------------------------------------------------------------------------------
 PostgreSQL 8.1.8 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.2
20061115 (prerelease) (Debian 4.1.1-21)
(1 row)

template1=#


Evergreen is 1.0.2.4 (I believe) from CVS.

Any help appreciated greatly!
--Don