Postgres Pro
Downloads
Home   >   mailing lists

Re: importing a 7.2 db with contrib/tsearch to 7.3 - Mailing list pgsql-sql

From Achilleus Mantzios
Subject Re: importing a 7.2 db with contrib/tsearch to 7.3
Date
Msg-id Pine.LNX.4.44.0211211310340.22698-100000@matrix.gatewaynet.com
Whole thread Raw
In response to importing a 7.2 db with contrib/tsearch to 7.3  (Andreas Joseph Krogh <andreak@officenet.no>)
Responses psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Ludwig Lim
Date:
Subject: Re: Drop NOT NULL constraint !!!
Next
From: Achilleus Mantzios
Date:
Subject: psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars