Re: Tsearch2 dump/reload problem
От | Michal Hlavac |
---|---|
Тема | Re: Tsearch2 dump/reload problem |
Дата | |
Msg-id | 41091411.40206@medium13.sk обсуждение исходный текст |
Ответ на | Re: Tsearch2 dump/reload problem (Michal Hlavac <hlavki@medium13.sk>) |
Список | pgsql-general |
Michal Hlavac wrote: > hello... > > I had another problem... I have table with tsvector type. > When I run pg_dump database > file.dat > > in the file.dat is in order first declaration of table and after that > declaration of type tsvector... > > After psql database < file.dat it returns error: > ERROR: type "tsvector" does not exist > ERROR: relation "t_auto_detail_seller" does not exist > ERROR: relation "t_auto_detail_seller" does not exist > sorry, solved... there was problem with regprocedure_7.4.patch.gz too... I had installed patch, but database needs to be reloaded with these steps: database e.g. hlk 1. shell: dump hlk > hlk.dat 2. psql: drop database hlk; create database hlk; 3. shell: psql hlk < tsearch2.sql 4. shell: psql hlk < hlk.dat 5. shell: pg_dump hlk_new.dat and after that hlk_new.dat is correct... hlavki
В списке pgsql-general по дате отправления: