Re: Error during a dump (ts_selectivity, not found) - Mailing list pgsql-general

From Tom Lane
Subject Re: Error during a dump (ts_selectivity, not found)
Date
Msg-id 20483.1295453408@sss.pgh.pa.us
Whole thread Raw
In response to Re: Error during a dump (ts_selectivity, not found)  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: Error during a dump (ts_selectivity, not found)
List pgsql-general
Adrian Klaver <adrian.klaver@gmail.com> writes:
> On Wednesday 19 January 2011 4:57:42 am Ahmed Ossama wrote:
>> I searched for the library ts_selectivity, but all in vain.

> Are you by any chance trying to restore a dump taken from a pre-8.3 server with
> Full Text Search to 8.3+ one? If so in 8.3 Full Text Search moved from being a
> contrib module to being integrated in the server.

That was never called "ts_selectivity", though.  Ahmed must be dealing
with some third-party extension module.  There's no such module in
pgfoundry, nor has Google ever heard of it, so I'm thinking it was
privately written code.

Do you really *need* to restore those objects?  If you just ignore the
errors, you'll get a restore without the custom functions ... but if you
don't know what they are, maybe you don't need them anymore.

            regards, tom lane

pgsql-general by date:

Previous
From: frank joerdens
Date:
Subject: debug_print_plan logs table alias used in join, not table name itself
Next
From: Jerry LeVan
Date:
Subject: How can I find a schema that a table belong to?