Skip to content

Instantly share code, notes, and snippets.

@jeff

jeff/output.txt Secret

Last active January 19, 2017 14:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jeff/acc4e11acff6f64f63ee81e1d24a5bce to your computer and use it in GitHub Desktop.
Save jeff/acc4e11acff6f64f63ee81e1d24a5bce to your computer and use it in GitHub Desktop.
pg_restore failure on actor_usr_family_name_unaccent_idx
# db created with
# psql -vdb_name=dbname -vcontrib_dir=/usr/share/postgresql/9.4/contrib -U evergreen -h localhost postgres -f /home/opensrf/Evergreen-ILS-2.11.1/Open-ILS/src/sql/Pg/create_database_extensions.sql
# restored with
# pg_restore -U evergreen -h localhost -d dbname file.dump
pg_restore: creating INDEX actor_usr_family_name_unaccent_idx
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 6913; 1259 17808 INDEX actor_usr_family_name_unaccent_idx evergreen
pg_restore: [archiver (db)] could not execute query: ERROR: function unaccent(text) does not exist
LINE 1: SELECT evergreen.lowercase(unaccent(regexp_replace(arg, '\s'...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
QUERY: SELECT evergreen.lowercase(unaccent(regexp_replace(arg, '\s','','g')))
CONTEXT: PL/pgSQL function evergreen.unaccent_and_squash(text) line 3 at RETURN
Command was: CREATE INDEX actor_usr_family_name_unaccent_idx ON usr USING btree (evergreen.unaccent_and_squash(family_name));
pg_restore: [archiver (db)] Error from TOC entry 6915; 1259 17806 INDEX actor_usr_first_given_name_unaccent_idx evergreen
pg_restore: [archiver (db)] could not execute query: ERROR: function unaccent(text) does not exist
LINE 1: SELECT evergreen.lowercase(unaccent(regexp_replace(arg, '\s'...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
QUERY: SELECT evergreen.lowercase(unaccent(regexp_replace(arg, '\s','','g')))
CONTEXT: PL/pgSQL function evergreen.unaccent_and_squash(text) line 3 at RETURN
Command was: CREATE INDEX actor_usr_first_given_name_unaccent_idx ON usr USING btree (evergreen.unaccent_and_squash(first_given_name));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment