[postgis-users] Install Posgrelsql 8.0.3 on Windows XP PRO

[patxi.mayol at free.fr]

why 8.0.3 ? 
it is the lastest release, no?
I novice in postgresql, so i have downloaded this version : postgresql-8.0.3_postgis-1.0.3_geos-2.1.3_proj-4.4.9-installeur
I have try your command createlang plpgsql SIG, but it say that the language is already install on SIG database !!

----- Mail Original -----
De: "Regina Obe" <robe.dnd at cityofboston.gov>
À: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Envoyé: Mardi 14 Avril 2009 14h28:42 GMT +01:00 Amsterdam / Berlin / Berne / Rome / Stockholm / Vienne
Objet: RE: [postgis-users] Install Posgrelsql 8.0.3 on Windows XP PRO

I'm sure there is a very good reason you are using the antiquated 8.0.3.
Just curious what is that  reason?

I'm guessing you forgot to install plpgsql language in your database.  

 createlang plpgsql SIG

then run the .sql files.

Hope that helps,
Regina

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
patxi.mayol at free.fr
Sent: Tuesday, April 14, 2009 8:20 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Install Posgrelsql 8.0.3 on Windows XP PRO

Hi,
I have install postgresql 8.0.3 with no problem; 
I want now try to install gis database : i use command on DOS like this
C:\postgresql>createdb SIG --> it is OK
C:\postgresql>psql -d SIG -f D:\postgresql\share\contrib\lwpostgis.sql
--> i have this message : 

psql:D:/postgresql/share/contrib/lwpostgis.sql:48: ERROR:  type
"histogram2d" already exists
psql:D:/postgresql/share/contrib/lwpostgis.sql:65: ERROR:  current
transaction is aborted, commands ignored until end of transaction block
psql:D:/postgresql/share/contrib/lwpostgis.sql:70: ERROR:  current
transaction is aborted, commands ignored until end of transaction block
.....

Have you an idea ?
thanks
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users