On Wed, 18 May 2005, Tom Lane wrote:
> Oleg Bartunov <oleg@sai.msu.su> writes:
>> any problem in restore. Unfortunately, pg_dump explicitly defines
>> search path to 'public, pg_catalog' and any objects from 'contrib' schema
>> doesn't seen, which cause many errors, for example, table uses type tsvector,
>> which defined in tsearch2 module, so that table doesn't created.
>
> Can you give a more specific example? Anything not in the search path
> should be explicitly schema-qualified in pg_dump's output. If it isn't,
> that's a bug.
unfortunately, no, because I deleted dump file. But, I just tried to
reproduce my problem with 8.0.3 and got no problem. I think, I tried
dump from 7.4.
>
> regards, tom lane
>
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