[postgis-users] AddGeometryColumn

[vittoriano.aurelio at libero.it]

PostgreSQL 9.0
PostGIS 1.5


what is my problem?


SET CLIENT_ENCODING TO UTF8;
SET STANDARD_CONFORMING_STRINGS TO ON;
BEGIN;
CREATE TABLE "particelle" (gid serial PRIMARY KEY,
"comune" varchar(4),
"sezione" varchar(1),
"foglio" varchar(4),
"allegato" varchar(1),
"sviluppo" varchar(1),
"numero" varchar(9),
"livello" varchar(11));
SELECT AddGeometryColumn('','particelle','the_geom','3003','MULTIPOLYGON',2);



NOTICE:  CREATE TABLE will create implicit sequence "particelle_gid_seq" for 
serial column "particelle.gid"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"particelle_pkey" for table "particelle"
ERROR:  function addgeometrycolumn(unknown, unknown, unknown, unknown, 
unknown, integer) does not exist
LINE 12: SELECT AddGeometryColumn('','particelle','the_geom','3003','...
                ^
HINT:  No function matches the given name and argument types. You might need 
to add explicit type casts.

********** Error **********

ERROR: function addgeometrycolumn(unknown, unknown, unknown, unknown, unknown, 
integer) does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You might need to 
add explicit type casts.
Character: 289


best regards


Vittoriano Aurelio