Re: Restoring a db dump with tsearch fields fails

> Which version of pgsql? which version of tsearch?

7.2.3, and whatever ver of tsearch is included in the contrib dir for
that.

> I had similar problems and emailed the creators of tsearch and they
> provided the fix. I believe it was later integrated back into
> the distro.

Don't suppose you still have that lying around? :)

> If you check the lines where those errors occur, I bet it is missing a
> single or double quote around those word.

Not sure it is that, but it could be I guess. From looking at the source
there are single quotes around all the tsearch words.

I've also tried dumping the database with:

pg_dump -Fc -b -c reviewer > reviewer.tar

But when I restore using:

pg_restore -Fc -C -d template1 reviewer.tar

I get the following error:

pg_restore: [archiver (db)] could not execute query: ERROR: Unable
to locate type name 'txtidx' in catalog

I've tried with and without including all the tsearch objects in
template1, when I have included them I just get a load of other errors
because the objects already exist.

Yours Unwhettedly,
Robert John Shepherd.

Editor
DVD REVIEWER
The UK's BIGGEST Online DVD Magazine
http://www.dvd.reviewer.co.uk

For a copy of my Public PGP key, email: pgp(at)robertsworld(dot)org(dot)uk