[postgis-users] PostGIS/PostgreSQL - error in creating table

[Mark Cave-Ayland]

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