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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])