| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| 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:02 |
| Message-ID: | 15133.1295287442@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
=?ISO-8859-1?Q?=22Plata_Mart=EDnez=2C_=C1lvaro_=28KNMI=29=22?= <alvaro(dot)plata(dot)martinez(at)knmi(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ludwig Kniprath | 2011-01-17 18:04:46 | Re: Postgis error |
| Previous Message | Frank Heikens | 2011-01-17 17:59:22 | Re: Postgis error |