Re: Subtle pg_dump problem...

Did you guys find any solution to this in the end?

Chris

Oleg Bartunov wrote:

> Thanks Christopher,
> we'll look into the issue.
> 
>     Oleg
> On Fri, 7 May 2004, Christopher Kings-Lynne wrote:
> 
> 
>>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
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 2: you can get off all lists at once with the unregister command
>>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>>
> 
> 
>     Regards,
>         Oleg
> _____________________________________________________________
> Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> Sternberg Astronomical Institute, Moscow University (Russia)
> Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
> phone: +007(095)939-16-83, +007(095)939-23-83