[postgis-users] possible bug: function st_asgeojson(geometry) is not unique

[Paragon Corporation]

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-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Tom van Tilburg
> Sent: Tuesday, July 10, 2012 6:33 AM
> To: postgis-users at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>