Postgis error

From: "Plata Martínez, Álvaro (KNMI)" <alvaro(dot)plata(dot)martinez(at)knmi(dot)nl>
To: pgsql-novice(at)postgresql(dot)org
Subject: Postgis error
Date: 2011-01-17 17:33:50
Message-ID: 4D347D7E.2050902@knmi.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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,
so I am not sure if I have to do anything else.

Thanks in advance for your help,
Alvaro.

Browse pgsql-novice by date

  From Date Subject
Next Message A B 2011-01-18 09:32:51 Question about object renaming in 9.0 (release note doc.)
Previous Message YAMAMOTO Takashi 2011-01-17 00:00:07 tuple concurrently updated