The following bug has been logged on the website:
Bug reference: 15264
Logged by: Brian Ceccarelli
Email address: ceccareb@talusmusic.com
PostgreSQL version: 10.4
Operating system: Red Hat Enterprise Linux 7.5
Description:
I create several text search dictionaries which point to my own stemmers.
When I pg_dump the database, a subsequent psql to load the database fails to
recreate them. My files exist, but psql shows.
CREATE TEXT SEARCH DICTIONARY
psql:10dollar.dmp:208298: ERROR: text search dictionary
"net32_en_us_no_stop_stemmer" does not exist
CREATE TEXT SEARCH CONFIGURATION
psql:10dollar.dmp:208309: ERROR: text search dictionary
"public.net32_en_us_thesaurus" does not exist
psql:10dollar.dmp:208312: ERROR: text search dictionary
"public.net32_en_us_thesaurus" does not exist
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH CONFIGURATION
psql:10dollar.dmp:208336: ERROR: text search dictionary
"public.net32_en_us_thesaurus" does not exist
psql:10dollar.dmp:208339: ERROR: text search dictionary
"public.net32_en_us_thesaurus" does not exist
ALTER TEXT SEARCH CONFIGURATION
psql:10dollar.dmp:208345: ERROR: text search dictionary
"public.net32_en_us_thesaurus" does not exist
psql:10dollar.dmp:208348: ERROR: text search dictionary
"public.net32_en_us_thesaurus" does not exist
ALTER TEXT SEARCH CONFIGURATION
--------------------------
A Postgres 9.6.2 to Postgres 10.4 does not fail when I use v9's pg_dump
command.
v9's pg_dump loads successfully to a Postgres 10.4 DB.
When I use Postgres's 10.4 pg_dump, then I get subsequent load failures.