Re: [SQL] postgre2postgre

2009-02-04 Thread Chris
F. wrote: Hello, I am trying to migrate from postgresql-8.1.11-1.el5_1.1 (i386) to postgresql-8.3.4-1.fc10.x86_64. But I can not. Database uses ltree and tsearch and the problem seems to be this. I am using, pg_dump in first computer and psql in second computer to execute script. First error:

Re: [SQL] postgre2postgre

2009-02-04 Thread Devrim GÜNDÜZ
On Wed, 2009-02-04 at 22:57 +0100, F. wrote: > First error: > psql:informatica.sql:24: ERROR: no se encuentra la función > «gtsvector_in» en el archivo «/usr/lib64/pgsql/tsearch2.so» > > Anyone know any way to migrate? Tsearch2 was integrated in core as of 8.3. You will need to read this: http:

[SQL] postgre2postgre

2009-02-04 Thread F.
Hello, I am trying to migrate from postgresql-8.1.11-1.el5_1.1 (i386) to postgresql-8.3.4-1.fc10.x86_64. But I can not. Database uses ltree and tsearch and the problem seems to be this. I am using, pg_dump in first computer and psql in second computer to execute script. First error: psql:inform