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

[Sandro Santilli]

On Tue, Jul 10, 2012 at 12:32:57PM +0200, Tom van Tilburg wrote:
> 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 (!).

Great.

> Thanks for your input!
> 
> P.S. Do I understand correctly that CREATE EXTENSION is not a
> preferred method for postgis?

It's actually a personal thing. I don't like it because it doesn't
let you easily upgrade between SVN revisions. There's no known bug
about it other than that (given yours was a false alarm :)

--strk;

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