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

Tom van Tilburg tom.van.tilburg at gmail.com
Tue Jul 10 03:32:57 PDT 2012

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?

More information about the postgis-users mailing list