[postgis-users] AddGeometryColumn error

[javier.estevez.ext at juntadeandalucia.es]

Now, with you purpose, this error:


ERROR:  no existe la relación «public.estac_aemet»
CONTEXTO:  sentencia SQL: «ALTER TABLE public.estac_aemet ADD COLUMN the_geom
geometry »
PL/pgSQL function "addgeometrycolumn" line 90 at EXECUTE statement
sentencia SQL: «SELECT AddGeometryColumn('', $1 , $2 , $3 , $4 , $5 , $6 )»
PL/pgSQL function "addgeometrycolumn" line 4 at SQL statement

>> First of all, Postgres display me the next error with this query:
>>
>> My database is named postgres
>> My table is named estac_aemet
>> The name of the new column I want to create is the_geom
>> 23030 is UTM-ED50 huso 30 (Proyection I want)
>>
>> SELECT addgeometrycolumn('postgres','estac_aemet', 'the_geom',
>> 23030,'POINT',2)
>>
>
> the first parameter is expected to be the schema name (default
> 'public' schema in your case, probably).
> command should be:
>
> SELECT addgeometrycolumn('public','estac_aemet', 'the_geom', 23030,'POINT',2)
>
> nicolas
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>