[postgis-users] postgis upgrade functions question

[John Callahan]

Thanks for your response.  I missed those instructions.  I was following
the README file that came with the alpha5 version.  Didn't think to check
the website.  Thanks!

My guess is that the old version of PostGIS I had installed was before the
alpha releases.  The version name reported was simply "PostGIS 2.0.0SVN".

I am sure the "function not unique" error has something to do with my
loading the old functions back in there via the database import.  I did run
uninstall_legacy.sql and reduced the number of functions to 957.  (I didn't
see a uninstall_legacy_raster.sql though, which is probably where the
problem lies.) I may just manually remove then reinstall all of the
functions.

- John

***********************************************
John Callahan, Research Scientist
Delaware Geological Survey, University of Delaware
URL: http://www.dgs.udel.edu
*************************************************



On Mon, Feb 20, 2012 at 2:12 PM, Bborie Park <bkpark at ucdavis.edu> wrote:

> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120220/7038104d/attachment.html>