| From: | Ludwig Kniprath <ludwig(at)kni-online(dot)de> |
|---|---|
| To: | "Plata Martínez, Álvaro (KNMI)" <alvaro(dot)plata(dot)martinez(at)knmi(dot)nl> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Postgis error |
| Date: | 2011-01-17 18:04:46 |
| Message-ID: | 4D3484BE.7010202@kni-online.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jensen Somers | 2011-01-17 18:21:05 | Re: Install PostgreSQL as part of a desktop application, but how to coop with existing installations? |
| Previous Message | Tom Lane | 2011-01-17 18:04:02 | Re: Postgis error |