[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, 
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

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




--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgis error

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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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 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.



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general