[postgis-users] AddGeometryColumn error

[Sufficool, Stanley]

The function is there and executing, however it is complaining that it
cannot find the table name in the public schema.

What was your original table create statement for the "estac_aemet"
table? "CREATE TABLE public.estac_aemet (field type, etc... "
Did you use special accent characters in its creation?


> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of javier.estevez.ext at juntadeandalucia.es
> Sent: Wednesday, August 27, 2008 8:13 AM
> To: PostGIS Users Discussion
> Cc: PostGIS Users Discussion
> Subject: Re: [postgis-users] AddGeometryColumn error
> 
> 
> Correctly, I have 3 databases: postgres (This my DB), 
> demo_postgis and template_postgis
> 
> In my DB there is no FUNCTIONS
> In template_postgis there are all the POSTGIS functions.
> 
> Can I import from 'my DB' all PostGIS functions that are in other DB
> (template_postgis)
> 
> Thanks.
> 
> > 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 
> _______________________________________________
> > 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
>