Hi Richard Thanks for your help. I'll try that.
Darragh On Wed, Oct 1, 2008 at 6:03 PM, Richard Huxton <[EMAIL PROTECTED]> wrote: > Darragh Gammell wrote: > > I am currently upgrading from 8.1 to 8.3 and am getting errors when > > restoring the dump from 8.1 into 8.3. Like below: > > > I have read this is due to the tsearch2 functions being moved into the > core > > section of postgres and I'll need to do some editing after the dump to > > change where the functions get referenced. > > What you want to do is exclude all the tsearch functions altogether, > since they're already in your 8.3 database. If you've installed all your > tsearch stuff into its own schema in 8.2 then there's an example at the > page below. > > http://sql-info.de/postgresql/notes/converting-tsearch2-to-8.3.html > > If not, you'll want to use the -l / -L options on pg_restore to generate > a list of all objects in your database. You can then comment out the > tsearch functions etc. and restore the db. Allow for some trial and > error on this. > > A pain, but hopefully the last time you'll need to do it. > > -- > Richard Huxton > Archonet Ltd > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
