Re: Subtle pg_dump problem... - Mailing list pgsql-hackers

Christopher, I don't quite understand the problem
Did you move pg_ts_* table to schema 'contrib' ?
What functions you schema-qualified and how ?
It's always required to set search_path properly.

Oleg
On Wed, 12 May 2004, Christopher Kings-Lynne wrote:

> 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
>
> ---------------------------(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