Oleg Bartunov <oleg(at)sai(dot)msu(dot)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.
regards, tom lane