Re: Subtle pg_dump problem...

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(at)postgresql(dot)org)
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83