Youssef, Ben mentioned the "create lang" step. I suspect this is what you are missing. The postgis functions are written in the language pl/Pgsql, which is an iptional add-on for any postgresql database. In order to add this language, you must do the following:
sudo su - postgres -c '/usr/local/pgsql/bin/createlang plpgsql [dbname]' Robert W. Burgholzer Surface Water Modeler Office of Water Supply and Planning Virginia Department of Environmental Quality [email protected] 804-698-4405 Open Source Modeling Tools: http://sourceforge.net/projects/npsource/ _____ From: [email protected] [mailto:[email protected]] On Behalf Of Youssef BEGHI Sent: Thursday, February 26, 2009 11:04 AM To: [email protected] Subject: [postgis-users] help : postgis on a mac os x Hello everyone , I'm not quite familiar with the GIS. I try to install postGIS in a mac os x (leopard) but it doesn't work when I performe the command : sudo su - postgres -c '/usr/local/pgsql/bin/psql -d [dbname] -f /usr/local/pgsql/share/lwpostgis.sql' with my dbname instead of [dbname] I recieve many error lines like these psql:/usr/local/pgsql/share/lwpostgis.sql:6500: ERROR: current transaction is aborted, commands ignored until end of please help, -- Youssef BEGHI ----------------------------------------------------------------- Sois heureux d'aujourd'hui ! Ne parle pas d'hier. [Omar Khayyâm]
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
