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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of [EMAIL PROTECTED] > 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 <[EMAIL PROTECTED]> > > > >> 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 [email protected] > >> > http://postgis.refractions.net/mailman/listinfo/postgis-users > >> > > >> > >> > >> _______________________________________________ > >> postgis-users mailing list [email protected] > >> http://postgis.refractions.net/mailman/listinfo/postgis-users > >> > > > > > > > > -- > > Luigi Castro Cardeles > _______________________________________________ > > postgis-users mailing list > > [email protected] > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > > _______________________________________________ > postgis-users mailing list [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
