Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id C06441337B69 for ; Wed, 22 Dec 2010 05:32:25 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 19931-04 for ; Wed, 22 Dec 2010 09:32:17 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from hermes.vectorsf.com (firewall.vectorsf.com [62.82.80.62]) by mail.postgresql.org (Postfix) with ESMTP id 93EEA1337999 for ; Wed, 22 Dec 2010 05:32:16 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by hermes.vectorsf.com (Postfix) with ESMTP id C7EED11C0240; Wed, 22 Dec 2010 10:32:13 +0100 (CET) X-Virus-Scanned: amavisd-new at hermes.vectorsf.com Received: from hermes.vectorsf.com ([127.0.0.1]) by localhost (hermes.vectorsf.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id iPw9RXbQNpEb; Wed, 22 Dec 2010 10:32:13 +0100 (CET) Received: from [10.70.4.200] (unknown [10.70.4.200]) (Authenticated sender: imartinez) by hermes.vectorsf.com (Postfix) with ESMTPSA id 7F5A111C0231; Wed, 22 Dec 2010 10:32:13 +0100 (CET) Subject: Re: Problems Upgrading from 8.2 to 9.0 From: =?ISO-8859-1?Q?I=F1igo?= Martinez Lasala To: Adib Cc: Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= , pgsql-admin@postgresql.org In-Reply-To: References: <1293000296.2291.2.camel@hp-laptop02.gunduz.org> Content-Type: multipart/alternative; boundary="=-wONzLKoyeMTOWXzJf0/d" Date: Wed, 22 Dec 2010 10:32:14 +0100 Message-ID: <1293010334.20992.108.camel@deimos> Mime-Version: 1.0 X-Mailer: Evolution 2.30.3 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.209 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_MED=-2.3, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/158 X-Sequence-Number: 36387 --=-wONzLKoyeMTOWXzJf0/d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8bit Adib, contrib/tsearch2.sql is a compatibility interface in order to avoid having to rewrite your application for > 8.3 tsearch2. In 8.3, tsearch2 was included in core. However, functions and procedures changed. So, a contrib module was included in order to translate old tsearch2 calls to new tsearch2. So, uninstalling tsearch2 in 8.2 will make your search not work. You will have also to deal with a change in data typing. Before 8.3, data typing checks where very lazy. After 8.3, these checks are hard. So, you will have to rewrite SQL sentences like this: SELECT * from table where integer='1' -> SELECT * from table where integer=1 or SELECT * from table where integer='1'::integer so types match. Migrating from 8.2 to 8.3 and higher versions can be a hard task if you have to check lot of SQL code. -----Original Message----- From: Adib To: Devrim GÜNDÜZ Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Problems Upgrading from 8.2 to 9.0 Date: Wed, 22 Dec 2010 00:01:14 -0800 I solved my problems by using the uninstall scripts located in the share/contrib in 8.2 to get rid of tsearch2 and fuzzymatch and that eliminated a lot of the errors I was running into. 2010/12/21 Adib Is there some way to avoid restoring tsearch2 since full text searching is now part of postgres 9.0, the apps that use the database don't do any full text searching. 2010/12/21 Devrim GÜNDÜZ On Tue, 2010-12-21 at 22:39 -0800, Adib wrote: > ERROR: type "tsvector" is only a shell > ERROR: operator class "gin_tsvector_ops" does not exist for access > method > "gin *IIRC*, you need to load contrib/tsearch2.sql to database *before* restoring your backup. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz --=-wONzLKoyeMTOWXzJf0/d Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: 7bit Adib, contrib/tsearch2.sql is a compatibility interface in order to avoid having to rewrite your application for > 8.3 tsearch2.
In 8.3, tsearch2 was included in core. However, functions and procedures changed. So, a contrib module was included in order to translate old tsearch2 calls to new tsearch2.

So, uninstalling tsearch2 in 8.2 will make your search not work.

You will have also to deal with a change in data typing. Before 8.3, data typing checks where very lazy. After 8.3, these checks are hard.
So, you will have to rewrite SQL sentences like this:
SELECT * from table where integer='1'   -> SELECT * from table where integer=1 or SELECT * from table where integer='1'::integer
so types match.

Migrating from 8.2 to 8.3 and higher versions can be a hard task if you have to check lot of SQL code.


-----Original Message-----
From: Adib <amslist@gmail.com>
To: Devrim GÜNDÜZ <devrim@gunduz.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Problems Upgrading from 8.2 to 9.0
Date: Wed, 22 Dec 2010 00:01:14 -0800

I solved my problems by using the uninstall scripts located in the share/contrib in 8.2 to get rid of tsearch2 and fuzzymatch and that eliminated a lot of the errors I was running into.

2010/12/21 Adib <amslist@gmail.com>
Is there some way to avoid restoring tsearch2 since full text searching is now part of postgres 9.0, the apps that use the database don't do any full text searching.



2010/12/21 Devrim GÜNDÜZ <devrim@gunduz.org>


On Tue, 2010-12-21 at 22:39 -0800, Adib wrote:
> ERROR:  type "tsvector" is only a shell
> ERROR:  operator class "gin_tsvector_ops" does not exist for access
> method
> "gin


*IIRC*, you need to load contrib/tsearch2.sql to database *before*
restoring your backup.

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz



--=-wONzLKoyeMTOWXzJf0/d--