After attempting to run:
psql -U evergreen -h localhost -f reingest-1.6-2.0.sql/
(running after running the perl script to re-ingest)
I get big errors here:
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:636: ERROR: cannot change name of input parameter "dest_usr"
HINT: Use DROP FUNCTION first.
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:653: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:712: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:714: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:716: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:720: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:722: ERROR: current transaction is aborted, commands ignored until end of transaction block
.....
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8850: ERROR: insert or update on table "org_unit_setting_type" violates foreign key constraint "org_unit_setting_type_grp_fkey"
DETAIL: Key (grp)=(circ) is not present in table "settings_group".
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8856: ERROR: duplicate key value violates unique constraint "perm_list_code_key"
DETAIL: Key (code)=(DEBUG_CLIENT) already exists.
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8866: ERROR: duplicate key value violates unique constraint "org_unit_setting_type_pkey"
DETAIL: Key (name)=(circ.user_merge.delete_addresses) already exists.
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8874: ERROR: duplicate key value violates unique constraint "org_unit_setting_type_pkey"
DETAIL: Key (name)=(circ.user_merge.delete_cards) already exists.
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8882: ERROR: duplicate key value violates unique constraint "org_unit_setting_type_pkey"
DETAIL: Key (name)=(circ.user_merge.deactivate_cards) already exists.
DROP TRIGGER
DROP TRIGGER
DROP TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
DROP TRIGGER
DROP TRIGGER
DROP TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8908: ERROR: relation "metabib.record_attr" does not exist
LINE 1: UPDATE metabib.record_attr
^
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8917: ERROR: relation "metabib.record_attr" does not exist
LINE 1: UPDATE metabib.record_attr