The only issue I see with CREATE EXTENSION at this point is that if you want to use the subversion releases because they don't have extension version points (which CREATE EXTENSION requires freeze points) , it's not upgradeable. I have a work around for that issue which I'm experimenting with. That only affects people who want to live on the edge like strk.
If you always go with released versions, it works just dandy from my experience. So in a nut-shell its fine for production use, just hard to use for interim synching with repository version. strk is just against it because he got bitten once early on and he had a mixed bag of stuff anyway. As far as upgrading from say 1.5. If you did an unclean upgrade -- brought over junk and installed on top of a clean postgis 2.0, YOU NEED to run the postgis_upgrade_minor script or you'll get ambiguous function calls as you've experienced. Hope that helps, Regina http://www.postgis.us > -----Original Message----- > From: postgis-users-boun...@postgis.refractions.net > [mailto:postgis-users-boun...@postgis.refractions.net] On > Behalf Of Tom van Tilburg > Sent: Tuesday, July 10, 2012 6:33 AM > To: postgis-users@postgis.refractions.net > Subject: Re: [postgis-users] possible bug: function > st_asgeojson(geometry) is not unique > > On 10-7-2012 12:16, Sandro Santilli wrote: > >> Also I see no double functions in public.functions nor are there > >> functions in any other place installed in the database. > > select * from pg_proc where proname = 'st_asgeojson'; (I > have 5 rows) > > > Seems I spoke too soon.. I just created a brand new empty > database and added postgis by extension. > It worked correctly. > > The previous database was also new but I imported a lot of > data that came from an earlier postgis database. Seems I > accidently copied some postgis functions somewhere because > "select * from pg_proc where proname = 'st_asgeojson';" > returned 11 rows (!). > > Thanks for your input! > > P.S. Do I understand correctly that CREATE EXTENSION is not a > preferred method for postgis? > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users