Re: pg_dump and using schema problem - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_dump and using schema problem
Date
Msg-id 24272.1116444992@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump and using schema problem  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: pg_dump and using schema problem  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-hackers
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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: pg_dump and using schema problem
Next
From: "Sergey Ten"
Date:
Subject: Re: patches for items from TODO list