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 <tgl@sss.pgh.pa.us> wrote:
Rebecca Clarke <rebecca@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.
