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" <[email protected]> À: "PostGIS Users Discussion" <[email protected]> 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: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, April 14, 2009 8:20 AM To: [email protected] 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 [email protected] 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 [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
