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