Re: Postgis error - Mailing list pgsql-general

From Frank Heikens
Subject Re: Postgis error
Date
Msg-id 4600B103-7160-4788-9870-CF57130137D9@mac.com
Whole thread Raw
In response to Postgis error  ("Plata Martínez, Álvaro (KNMI)"<alvaro.plata.martinez@knmi.nl>)
List pgsql-general
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




pgsql-general by date:

Previous
From: Gary Chambers
Date:
Subject: Re: iPad and Postgresql...
Next
From: Tom Lane
Date:
Subject: Re: Postgis error