Re: [GENERAL] Postgis error

2011-01-17 Thread Ludwig Kniprath
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)": Hi, Using

Re: [GENERAL] Postgis error

2011-01-17 Thread Tom Lane
=?ISO-8859-1?Q?=22Plata_Mart=EDnez=2C_=C1lvaro_=28KNMI=29=22?= 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

Re: [GENERAL] Postgis error

2011-01-17 Thread Frank Heikens
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 a

[GENERAL] Postgis error

2011-01-17 Thread Plata Martínez, Álvaro (KNMI)
Hi, 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 I supposed that installing postgis I would get the geographical object