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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
