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------' _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users