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

[Sandro Santilli]

On Tue, Jul 10, 2012 at 11:57:33AM +0200, Tom van Tilburg wrote:
> I upgraded my postgis libraries from 2.0.0  to 2.0.1 but did a clean
> install with CREATE EXTENSION to a new database after that.

Could be a bug with CREATE EXTENSION. Could you try with "the old way"
to confirm ? If confirmed, this will be very worth opening a ticket for.

> 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)

> version output is:
>     "POSTGIS="2.0.1 r9979" GEOS="3.3.5-CAPI-1.7.5" PROJ="Rel. 4.8.0,
> 6 March 2012" GDAL="GDAL 1.9.1, released 2012/05/15" LIBXML="2.7.8"
> TOPOLOGY RASTER"
> 
> Does it work for you?

Yes, but only tried on a pre-existing database, and not enabled
with CREATE EXTENSION.

--strk;

  ,------o-. 
  |   __/  |    Delivering high quality PostGIS 2.1
  |  / 2.1 |    http://strk.keybit.net - http://vizzuality.com
  `-o------'