I have a table with a tsearch2 index on it. Now, I have all the
tsearch2 stuff installed into a 'contrib' schema. I have had to change
the default database schema to include the contrib schema as
behind-the-scenes, tsearch2 looks for its tables, and cannot find them
even if the function itself is schema-qualfified. This might well be a
tsearc2 bug.
Anyway, this means the table is dumped like this:
SET SESSION AUTHORIZATION 'auadmin';
SET search_path = public, pg_catalog;
COPY ...
Which give this error upon restoring:
ERROR: relation "pg_ts_cfg" does not exist
CONTEXT: COPY food_categories, line 1: "79 102 Vegetables,
Salads & Legumes \N 'legum':3 'salad':2 'veget':1"
It's because the search_path needs to be like this for it to work:
SET search_path = public, contrib, pg_catalog;
Chris