Re: Question

Mar=EDa Jos=E9 Peir=F3 Sim=F3 wrote:
> We are students of the Universidad Polit=E9cnica de Valencia and we hav=
e had
> problems with the installation of Postgre 8.2.3
>=20
> First of all, sorry about our english, but I suposse we can understand.
>=20
> We installed Postgre 8.2.3 for Windows from www.postgresql.org and it r=
an well.
> The problem began when we uninstalled that, and installed Postgis. All =
the
                              ^^^^^^^^^^

You are *not* supposed to uninstall PostgreSQL.  The PostGIS website says=
=20
that, to install PostGIS, you have to:

Un-tar the PostGIS tar-ball in the 'contrib' directory of your PostgreSQL=
=20
source tree. You must have the PL/pgSQL prodedural language installed=20
before installing PostGIS.

tar xvfz postgis-1.1.0.tar.gz
cd postgis-1.1.0
./configure
make
make install
createlang plpgsql yourtestdatabase
psql -d yourtestdatabase -f lwpostgis.sql
psql -d yourtestdatabase -f spatial_ref_sys.sql

You may want to look at the PostGIS site for documentation:=20
http://postgis.refractions.net/documentation/

Thank you very much.

Best Regards,

Carlo

--=20
Carlo Florendo
Softare Engineer/Network Co-Administrator
Astra Philippines Inc.
UP-Ayala Technopark, Diliman 1101, Quezon City
Philippines
http://www.astra.ph

--
The Astra Group of Companies
5-3-11 Sekido, Tama City
Tokyo 206-0011, Japan
http://www.astra.co.jp

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match