Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C2D2447625A for ; Thu, 21 Nov 2002 06:05:59 -0500 (EST) Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by postgresql.org (Postfix) with ESMTP id 9107747629D for ; Thu, 21 Nov 2002 06:05:57 -0500 (EST) Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.11.6/8.11.6) with ESMTP id gALBDOL22709; Thu, 21 Nov 2002 13:13:24 +0200 Date: Thu, 21 Nov 2002 13:13:24 +0200 (EET) From: Achilleus Mantzios To: Andreas Joseph Krogh Cc: pgsql-sql@postgresql.org Subject: Re: importing a 7.2 db with contrib/tsearch to 7.3 In-Reply-To: <200211211155.42539.andreak@officenet.no> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/326 X-Sequence-Number: 10468 Thats what i do for intarray: -Install all contrib packages you want to use (*before* restoring your DB) -Restore Your DB -Look in log for errors -Correct them. Normally all you shoud get is a bunch of notices that somethings are allready defined. I had the same problem as you with gist indexes in intarray. ================================================================== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-10-8981112 fax: +30-10-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr