Re: Restoring a db dump with tsearch fields fails
От | Robert John Shepherd |
---|---|
Тема | Re: Restoring a db dump with tsearch fields fails |
Дата | |
Msg-id | 004701c28724$4a82e560$f3b0313e@LAIKA обсуждение исходный текст |
Ответ на | Re: Restoring a db dump with tsearch fields fails ("Thomas T. Thai" <tom@minnesota.com>) |
Ответы |
Re: Restoring a db dump with tsearch fields fails
|
Список | pgsql-general |
> 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@robertsworld.org.uk
В списке pgsql-general по дате отправления: