Re: Tsearch2 dump/reload problem

--- 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