Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump and tsearch2 - Mailing list pgsql-general

From Michal Hlavac
Subject Re: pg_dump and tsearch2
Date
Msg-id 40C4395F.1040602@medium13.sk
Whole thread Raw
In response to Re: pg_dump and tsearch2  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: pg_dump and tsearch2
List pgsql-general
Tree view 
sorry for my strictness. My problem is with type tsvector.

I have table in my schema with column of tsvector type. During importing
  dump.dat (with psql database < dump.dat) postgresql returns:
ERROR:  type "tsvector" does not exist

It is because declaration of tsvector is after declaration of table with
tsvector column...

That patch is for procefures... Or there is some other problems...
I am using 7.4.2 on cygwin.

thanks, hlavki

pgsql-general by date:

Previous
From: Karel Zak
Date:
Subject: Re: Turn off "money" formatting?
Next
From: Richard Huxton
Date:
Subject: Re: Backup and Restore of PostgreSQL