[postgis-users] AddGeometryColumn

[Ben Madin]

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.aurelio at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users