=?ISO-8859-1?Q?=22Plata_Mart=EDnez=2C_=C1lvaro_=28KNMI=29=22?= <alvaro.plata.martinez@knmi.nl> 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