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
