Re: pg_dump and tsearch2 - Mailing list pgsql-general

From Teodor Sigaev
Subject Re: pg_dump and tsearch2
Date
Msg-id 40C43542.2030405@sigaev.ru
Whole thread Raw
In response to pg_dump and tsearch2  (Michal Hlavac <hlavki@medium13.sk>)
Responses Re: pg_dump and tsearch2  (Michal Hlavac <hlavki@medium13.sk>)
List pgsql-general
Yes, it's possible.

Michal Hlavac wrote:
> Hellou,
>
> when I use
> pg_dump database > dump.dat
> on database with tsearch2 and then
> psql database < dump.dat - this command fails, because in dump.dat is
> declaration of tsearch2 procedures and types after main schema, which is
> using tsearch2.
>
> is this patch for this??
> http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/regprocedure_7.4.patch.gz
>
>
> How Can I use this patch on cygwin???
>
> thank you, hlavki
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>      joining column's datatypes do not match

--
Teodor Sigaev                                  E-mail: teodor@sigaev.ru

pgsql-general by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: [HACKERS] CREATE DATABASE on the heap with PostgreSQL?
Next
From: Karel Zak
Date:
Subject: Re: Turn off "money" formatting?