Re: Postgis error

Op 17 jan 2011, om 18:35 heeft Plata Martínez, Álvaro (KNMI) het
volgende geschreven:

> Hi,
>
> Using postgreSQL 8.4 and Postgis 1.4 in an Ubuntu 10.04 Server,

Did also install the PostGIS-functions, types, etc. in your database?
Installing PostGIS is a combination of installing the package and the
SQL-parts. Check this article:
http://www.paolocorti.net/2008/01/30/installing-postgis-on-ubuntu/

> when trying to create a table:
> CREATE TABLE observation (
> (...)
> spatial_value geometry,
> );
>
> I get this error message:
> ERROR: type "geometry" does not exist
>
> I supposed that installing postgis I would get the geographical
> object, so I am not sure if I have to do anything else.
>
> Thanks in advance for your help,
> Alvaro.
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


Regards,
Frank Heikens