[postgis-users] postgis upgrade functions question

[Bborie Park]

John,

Based upon what you're describing, it sounds like you do have
duplicative sets of functions.  As I don't know what version of
PostGIS you upgraded from, I can't provide any specific advice.  At
the moment, the hard upgrade needs to be following the instructions
described at:

http://postgis.refractions.net/documentation/manual-svn/postgis_installation.html#hard_upgrade

-bborie

On Mon, Feb 20, 2012 at 11:05 AM, John Callahan <john.callahan at udel.edu> wrote:
> I recently upgraded to PostGIS alpha5 version (using Postgres 9.0.2) on
> Windows.   I believe I performed a hard upgrade (dumped my old database, ran
> postgis install scripts into a new database, import previous database dump.)
>   All seemed to work well.
>
> Now, I am working with raster data.  I loaded a test raster fine.  When I
> tried to access that data, I received "ERROR:  function st_value(raster,
> geometry) is not unique".   When I checked through pgAdmin, I see about 1026
> functions in my database.  ST_Value is in there 8 times with different
> variations, some with the same number of arguments.
>
> Could this be because when I exported my old database, I used pg_dumpall,
> which included the functions, on top of what was already there?  As a fix,
> could I simply delete all of the functions through pgAdmin, then
> run postgis-pg90-binaries-2.0.0alpha5\share\contrib\postgis-2.0\ postgis.sql
> and rtpostgis.sql?
>
> - John
>
> ***********************************************
> John Callahan, Research Scientist
> Delaware Geological Survey, University of Delaware
> URL: http://www.dgs.udel.edu
> *************************************************
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu