supunmali wrote:
Thank you so much for giving the idea!!! :)
I found this, it works.
w/o using template_postgis these 2 sqls can run in query tool of Pgadmin111
Program files\Postgresql\8.3\share\contrib\lwpostgis.sql
Program files\Postgresql\8.3\share\contrib\spatial_ref_sys.sql
(http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01)
This sounds as if you were connected to the database server via the
template_postgis database which is why you were unable to create a
database from the template since it was considered active. You need to
use another database, typically the postgres database generated during
installation is used for these kinds of administration tasks.
HTH,
Mark.
--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
