Pk, Sorry about that. We don't have the comments.sql generation set to check the version of GEOS. That is on my todo. Though ideally I would just prefer that we make the required the minimum GEOS that can support all the functions we include in a release, if nothing more than to avoid this confusion.
You could just remark out those lines and it will work fine. Actually it should just skip over those errors anyway since they aren't in a transaction. The comments file just loads helper information about each function so that if you are browsing the functions via psql or PgAdmin III, you will see the brief summary about each function and what its for. Now why those parts fail is because with GEOS 2.2.3 you don't get those functions. Those functions were introduced in GEOS 3+ If you look at the docs for these you'll see GEOS >= 3... http://postgis.refractions.net/documentation/manual-1.4.1SVN/ST_Covers.html http://postgis.refractions.net/documentation/manual-1.4.1SVN/ST_CoveredBy.ht ml http://postgis.refractions.net/documentation/manual-1.4.1SVN/ST_SimplifyPres erveTopology.html If you can upgrade your GEOS, I would highly suggest you do because there are a lot of improvements (and bug fixes) in GEOS 3.1 that you are missing with GEOS 2.2.3. For example you won't be able to take benefit of the prepared geometry enhancements and there are some bug fixes in 3.0+ that were not back-ported to GEOS 2.2... I forget what those are exactly though. Thanks, Regina -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Pena Kupen Sent: Monday, August 24, 2009 4:14 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] functions st_covers, st_coveredby, st_simplifypreservetopology does not exist Hi all, My environment seems now be correct with Postgres 8.4, postgis 1.3.6 and geos 2.2.3. All script, except this postgis_comments.sql are loaded ok. I still got errors: psql -f postgis_comments.sql -Upostgres -d mydb psql:postgis_comments.sql:291: ERROR: function st_covers(geometry, geometry) does not exist psql:postgis_comments.sql:293: ERROR: function st_coveredby(geometry, geometry) does not exist psql:postgis_comments.sql:381: ERROR: function st_simplifypreservetopology(geometry, double precision) does not exist They are in comments which is not required, but I like to know, what am I missing? btw: I seems, that I cannot post reply to thread - why and how to do it? All of my reply's are new threads. -- pk -- Saunalahti DataPaketti - tilaa nyt, saat 2 kk veloituksetta ja Nettitikun kaupan päälle! http://saunalahti.fi/gsm/gsmdatapaketti.php _______________________________________________ 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
