... A patch exist for tsearch to regenerate oids when a dump file is loaded into a new database. Future versions of tsearch will not have a problem with dumping and reloading. For now to apply the patch, download the following file to the root of your PostgreSQL source tree (not contrib/tsearch2). http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/regprocedure_7.4.patch.gz In the root of your PostgreSQL source tree, it's assumed that you have run configure with the options you want. ...