Your right. I'm actually transferring from 8.2. Dumb moment for me there! I am using tsvector so unable to uninstall. I will look into documentation.. Thanks for your help. Rebecca
On Thu, Oct 13, 2011 at 3:43 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Rebecca Clarke <rebe...@clarke.net.nz> writes: > > I'm transferring a database from 8.3 to 8.4 and I've done a pg_dump of > the > > db schema on 8.3. When I pg_restore it to 8.4 I get the following: > > > pg_restore: creating FUNCTION gtsq_in(cstring) > > pg_restore: [archiver (db)] Error from TOC entry 550; 1255 4231868780 > > FUNCTION gtsq_in(cstring) postgres > > pg_restore: [archiver (db)] could not execute query: ERROR: could not > find > > function "gtsq_in" in file "/usr/lib/postgresql/8.4/lib/tsearch2.so" > > Command was: CREATE FUNCTION gtsq_in(cstring) RETURNS gtsq > > AS '$libdir/tsearch2', 'gtsq_in' > > LANGUAGE c STRICT; > > Were you *really* on 8.3 before? Because that function hasn't existed > since 8.2. > > You need to follow the procedure for updating pre-8.3 tsearch2 > installations, as described in the manual: > http://www.postgresql.org/docs/8.4/static/textsearch-migration.html > (I believe BTW that some errors of the sort you show above are expected > while doing this process. If that's what you're doing, just ignore it.) > > Alternatively, if you weren't actually doing anything with the > contrib/tsearch2 functions, you could just uninstall them from the older > database and then repeat the dump. > > regards, tom lane >
