Re: Tsearch2 dump/reload problem - Mailing list pgsql-general

From Chris Gamache
Subject Re: Tsearch2 dump/reload problem
Date
Msg-id 20040729125125.73128.qmail@web13810.mail.yahoo.com
Whole thread Raw
In response to Re: Tsearch2 dump/reload problem  (Ian Barwick <barwick@gmail.com>)
List pgsql-general
--- Ian Barwick <barwick@gmail.com> wrote:

> I _think_ the way round this is to drop all the tsearch2 objects - you
> should have an untsearch2.sql file in a contrib directory somewhere
> which contains the appropriate statements. This does of course cascade
> to tsvector columns, which you will have to recreate and repopulate.
>
> FWIW I put all tsearch-related objects into their own schema, and
> recreate this before restoring other data to a fresh database.

Thank you. Dropping and re-loading tsearch2 objects worked like a charm.

The regprocedure_7.4.patch.gz actually works now! It's a great feature. I wish
I had noticed it sooner. I wonder why it didn't make it into pgsql-announce?

I am still considering your suggestion for putting the tsearch2 objects into
their own schema: Nice and clean.

CG



__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail

pgsql-general by date:

Previous
From: LISTMAN
Date:
Subject: Undefined symbol in plpgsql.so library
Next
From: "David Parker"
Date:
Subject: tablespace spec