=?ISO-8859-1?Q?=22Plata_Mart=EDnez=2C_=C1lvaro_=28KNMI=29=22?= <alvaro.plata.martinez@xxxxxxx> writes: > Using postgreSQL 8.4 and Postgis 1.4 in an Ubuntu 10.04 Server, when > trying to create a table: > CREATE TABLE observation ( > (...) > spatial_value geometry, > ); > I get this error message: > ERROR: type "geometry" does not exist It looks like you didn't actually install PostGIS into the database. Just putting the library on your machine isn't enough: you have to run a SQL script to declare all the functions in each database you want to use PostGIS in. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
