Re: Tsearch2 dump/reload problem

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