-
-
Save jeff/acc4e11acff6f64f63ee81e1d24a5bce to your computer and use it in GitHub Desktop.
pg_restore failure on actor_usr_family_name_unaccent_idx
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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