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