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-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of patxi.ma...@free.fr Sent: Tuesday, April 14, 2009 8:20 AM To: postgis-users@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@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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
