Advertisement
Guest User

Untitled

a guest
Jan 19th, 2017
178
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.86 KB | None | 0 0
  1. pg_restore: creating INDEX actor_usr_second_given_name_idx
  2. pg_restore: creating INDEX actor_usr_first_given_name_unaccent_idx
  3. pg_restore: [archiver (db)] Error while PROCESSING TOC:
  4. pg_restore: [archiver (db)] Error from TOC entry 8291; 1259 2712101 INDEX actor_usr_first_given_name_unaccent_idx postgres
  5. pg_restore: [archiver (db)] could not execute query: ERROR: function unaccent(text) does not exist
  6. LINE 1: SELECT evergreen.lowercase(unaccent(regexp_replace(arg, '\s'...
  7. ^
  8. HINT: No function matches the given name and argument types. You might need to add explicit type casts.
  9. QUERY: SELECT evergreen.lowercase(unaccent(regexp_replace(arg, '\s','','g')))
  10. CONTEXT: PL/pgSQL function evergreen.unaccent_and_squash(text) line 3 at RETURN
  11. Command was: CREATE INDEX actor_usr_first_given_name_unaccent_idx ON usr USING btree (evergreen.unaccent_and_squash(first_given_name));
  12.  
  13.  
  14.  
  15. pg_restore: finished item 8291 INDEX actor_usr_first_given_name_unaccent_idx
  16. pg_restore: launching item 8299 INDEX actor_usr_second_given_name_unaccent_idx
  17. pg_restore: creating INDEX actor_usr_second_given_name_unaccent_idx
  18. pg_restore: [archiver (db)] Error while PROCESSING TOC:
  19. pg_restore: [archiver (db)] Error from TOC entry 8302; 1259 2713703 INDEX actor_usr_usrname_unaccent_idx postgres
  20. pg_restore: [archiver (db)] could not execute query: ERROR: function unaccent(text) does not exist
  21. LINE 1: SELECT evergreen.lowercase(unaccent(regexp_replace(arg, '\s'...
  22. ^
  23. HINT: No function matches the given name and argument types. You might need to add explicit type casts.
  24. QUERY: SELECT evergreen.lowercase(unaccent(regexp_replace(arg, '\s','','g')))
  25. CONTEXT: PL/pgSQL function evergreen.unaccent_and_squash(text) line 3 at RETURN
  26. Command was: CREATE INDEX actor_usr_usrname_unaccent_idx ON usr USING btree (evergreen.unaccent_and_squash(usrname));
  27.  
  28.  
  29.  
  30. pg_restore: finished item 8302 INDEX actor_usr_usrname_unaccent_idx
  31. pg_restore: launching item 8300 INDEX actor_usr_usrgroup_idx
  32. pg_restore: creating INDEX actor_usr_usrgroup_idx
  33. pg_restore: [archiver (db)] Error while PROCESSING TOC:
  34. pg_restore: [archiver (db)] Error from TOC entry 8289; 1259 2712103 INDEX actor_usr_family_name_unaccent_idx postgres
  35. pg_restore: [archiver (db)] could not execute query: ERROR: function unaccent(text) does not exist
  36. LINE 1: SELECT evergreen.lowercase(unaccent(regexp_replace(arg, '\s'...
  37. ^
  38. HINT: No function matches the given name and argument types. You might need to add explicit type casts.
  39. QUERY: SELECT evergreen.lowercase(unaccent(regexp_replace(arg, '\s','','g')))
  40. CONTEXT: PL/pgSQL function evergreen.unaccent_and_squash(text) line 3 at RETURN
  41. Command was: CREATE INDEX actor_usr_family_name_unaccent_idx ON usr USING btree (evergreen.unaccent_and_squash(family_name));
  42.  
  43.  
  44.  
  45. pg_restore: finished item 8289 INDEX actor_usr_family_name_unaccent_idx
  46. pg_restore: launching item 8295 INDEX actor_usr_mailing_address_idx
  47. pg_restore: creating INDEX actor_usr_mailing_address_idx
  48. pg_restore: [archiver (db)] Error from TOC entry 8299; 1259 2712102 INDEX actor_usr_second_given_name_unaccent_idx postgres
  49. pg_restore: [archiver (db)] could not execute query: ERROR: function unaccent(text) does not exist
  50. LINE 1: SELECT evergreen.lowercase(unaccent(regexp_replace(arg, '\s'...
  51. ^
  52. HINT: No function matches the given name and argument types. You might need to add explicit type casts.
  53. QUERY: SELECT evergreen.lowercase(unaccent(regexp_replace(arg, '\s','','g')))
  54. CONTEXT: PL/pgSQL function evergreen.unaccent_and_squash(text) line 3 at RETURN
  55. Command was: CREATE INDEX actor_usr_second_given_name_unaccent_idx ON usr USING btree (evergreen.unaccent_and_squash(second_given_name));
  56.  
  57.  
  58.  
  59. pg_restore: finished item 8299 INDEX actor_usr_second_given_name_unaccent_idx
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement