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

[Don McMorris]

As usual... fixed 5 minutes after I sent the message...  It was a CVS
snapshot... I got the "official" tarball and ran the "build-db.sh"
from it.  It worked, and fixed the issue.

Woohoo...

On 2/25/07, Don McMorris <don.mcmorris at gmail.com> wrote:
> 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
>