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

=?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

Hi,
for adding a geometry-column to an existing table use one of the
postgis-functions "select AddGeometryColumn(...);" described in:

http://postgis.refractions.net/documentation/manual-1.5/AddGeometryColumn.html

Ludwig

Am 17.01.2011 18:35, schrieb "Plata Mart�nez, �lvaro (KNMI)":