Vittoriano,
Try it
without the empty '' for the schema (or specify the schema - probably
'public'),
and
the SRID should be an integer.
SELECT AddGeometryColumn('particelle','the_geom',3003,'MULTIPOLYGON',2);
might work.
(Assuming that you have loaded the postgis.sql functions into your database
first?)
cheers
Ben
On 26/05/2011, at 4:37 PM, vittoriano.aure...@libero.it wrote:
> 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
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
