[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] AddGeometryColumn
From:       Ben Madin <lists () remoteinformation ! com ! au>
Date:       2011-05-26 9:12:11
Message-ID: EB33DDCB-208C-41FF-AAF1-6360C7CDF1CB () remoteinformation ! com ! au
[Download RAW message or body]

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@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
[prev in list] [next in list] [prev in thread] [next in thread]