[postgis-users] AddGeometryColumn error

[Luigi Castro Cardeles]

Hi,

maybe your instalation of postgis functions and etc are not in postgres db.
If you are using windwos search for others databases, maybe a postgis or
postgis_template. At that databases you will find the the functions.

If you are using linux then you will have to add that functions to some
database, see the docs for a how-to.

A good policy is to create a new database using a template with the postgis
stuff. Leave the postgres db for maintenance.

Best regards,

2008/8/27 <javier.estevez.ext at juntadeandalucia.es>

> No, is correct like 'estac_aemet'
>
> How do I know if my POSTGIS functions are installed ok?
>
> In my DB called 'postgres' I have no Functions.
>
>
>
> >> Yes, the tabla estac_aemet exists. The schema is public
> >>
> >
> > Did you create the table using double quotes to name it ? "ESTAC_AEMET"
> maybe
> > ?
> > If so, then you have to respect the case in the table name when naming
> it:
> >
> > SELECT addgeometrycolumn('public','ESTAC_AEMET', 'the_geom',
> 23030,'POINT',2)
> >
> > You can check the table name by launching psql and typing \d to list all
> > tables.
> >
> >
> > Nicolas
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
Luigi Castro Cardeles
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080827/5178a94c/attachment.html>