| From: | Rebecca Clarke <rebecca(at)clarke(dot)net(dot)nz> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Transfer 8.3 to 8.4 - FUNCTION gtsq_in(cstring) does not exist |
| Date: | 2011-10-13 10:20:06 |
| Message-ID: | CANY3h+Qy=Gdp9MTRvJ536B0cyZuTEA-AUUE9YPYFYLTi0LxQGw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi
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;
I'm getting the same error when it tries to create function
gtsq_out(cstring), gtsvector_out(cstring) and gtsvector_in(cstring) as well
I've run the tsearch2.sql in /usr/share/postgresql/8.4/contrib but still no
go. I can't seem to find any info on web either.
Rebecca
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rebecca Clarke | 2011-10-13 10:42:05 | Transfer 8.3 to 8.4 - FUNCTION gtsq_in(cstring) does not exist |
| Previous Message | Devrim GÜNDÜZ | 2011-10-13 09:31:10 | Re: I need to load mysql dump to postgres... |