[postgis-users] How to update your SVN copy of PostGIS

[Stephen Woodbridge]

You can ignore all the notices. As long as you do not get a rollback, 
then things should be ok.

The script is just trying to clean out potential obsolete functions that 
might be there if the database was created many versions ago and 
upgraded to this point.

-Steve W

On 12/10/2011 5:46 PM, Aren Cambre wrote:
> Thanks. Yup, I see it now. My mind was stuck in 3rd generation languages
> where things stop when you get an exception.
>
> The script's first gripe was that the *spatial_ref_sys* table already
> exists. Shouldn't it automatically kill and reload that table? Is that a
> bug?
>
> Anyway, I deleted it and reran the script. Now I get a bunch of notices
> about functions that don't exist. See attachment.
>
> It appears it's mostly not finding overloads of functions. E.g., it says
> *populate_geometry_columns()* and *populate_geometry_columns(oid)* are
> missing. I do have variants with different function signatures:
> *populate_geometry_columns(oid,boolean)* and
> *populate_geometry_columns(boolean)*.
>
> BTW, I'm trying to run this on my template PostGIS DB, which I named
> *spatial_db_template*.
>
> Aren
>
> On Sat, Dec 10, 2011 at 10:26 AM, Bborie Park <bkpark at ucdavis.edu
> <mailto:bkpark at ucdavis.edu>> wrote:
>
>     Oops!  My head is always in the raster world, so I just ran with the
>     raster upgrade.  Sorry about that.
>
>     If you're getting an error, you'll want to scroll up past the
>     transaction error message as the very first error message should be
>     related to the actual statement that is failing.
>
>     -bborie
>
>     On Sat, Dec 10, 2011 at 6:47 AM, Aren Cambre <aren at arencambre.com
>     <mailto:aren at arencambre.com>> wrote:
>      > Thanks. Yesterday I
>      >
>     found postgis_upgrade_20_minor.sql in /usr/share/postgresql/9.1/contrib/postgis-2.0.
>      >
>      > When I ran that, I got tons of errors like this:
>      >
>     psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:3235:
>      > ERROR:  current transaction is aborted, commands ignored until end of
>      > transaction block
>      >
>      > I see you mentioned rtpostgis_upgrade_20_minor.sql. Isn't that
>     just for
>      > raster functions? I searched my machine and cannot find it, anyway.
>      >
>      > Aren
>      >
>      > On Fri, Dec 9, 2011 at 10:02 PM, Bborie Park <bkpark at ucdavis.edu
>     <mailto:bkpark at ucdavis.edu>> wrote:
>      >>
>      >> Aren,
>      >>
>      >> Since you're tracking trunk, after you've done the configure,
>     make and
>      >> make install, you'll want to run the upgrade script
>      >>
>      >> rtpostgis_upgrade_20_minor.sql
>      >>
>      >> Usually, the file is installed in the same place as
>     rtpostgis.sql.  If
>      >> you can't find the upgrade file, you can find it in your checkout's
>      >> directory at:
>      >>
>      >> raster/rt_pg
>      >>
>      >> -bborie
>      >>
>      >> On Fri, Dec 9, 2011 at 7:53 PM, Aren Cambre <aren at arencambre.com
>     <mailto:aren at arencambre.com>> wrote:
>      >> > Thanks. I got the latest SVN snapshot. I was able to
>     configure, make,
>      >> > and
>      >> > make install. The problem is there seems to be missing steps
>     between
>      >> > building the whole thing and getting changes into my preexisting
>      >> > PostGIS-enabled database.
>      >> >
>      >> > Aren
>      >> >
>      >> >
>      >> > On Fri, Dec 9, 2011 at 9:47 PM, Bborie Park
>     <bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>> wrote:
>      >> >>
>      >> >> If you used something like...
>      >> >>
>      >> >> svn check out https://svn.osgeo.org/postgis/trunk
>      >> >>
>      >> >> You can safely run...
>      >> >>
>      >> >> svn update
>      >> >>
>      >> >> If that works, I'd recommend doing...
>      >> >>
>      >> >> svn cleanup
>      >> >>
>      >> >> -bborie
>      >> >>
>      >> >> On Fri, Dec 9, 2011 at 7:19 PM, Aren Cambre
>     <aren at arencambre.com <mailto:aren at arencambre.com>>
>      >> >> wrote:
>      >> >> > I admit this is a dumb question, but here it is.
>      >> >> >
>      >> >> > I installed PostGIS on my Ubuntu 11.10 environment a few
>     weeks ago
>      >> >> > using
>      >> >> > the
>      >> >> > excellent instructions
>      >> >> > at
>     http://www.letseehere.com/postgis-geocoder-using-tiger-2010-data.
>      >> >> >
>      >> >> > Since then, the geocode_intersection function was added,
>     and I need
>      >> >> > it.
>      >> >> > I'm
>      >> >> > not clear what is the process of replacing the older
>     snapshot of
>      >> >> > PostGIS
>      >> >> > with this newer one.
>      >> >> >
>      >> >> > I don't see an obvious install/uninstall routine. I tried
>     the soft
>      >> >> > upgrade
>      >> >> >
>      >> >> >
>      >> >> > at
>     http://postgis.refractions.net/documentation/manual-svn/postgis_installation.html#upgrading,
>      >> >> > but that didn't work. Do I need to do the hard upgrade each
>     time I do
>      >> >> > a
>      >> >> > SVN
>      >> >> > update?
>      >> >> >
>      >> >> > Aren
>      >> >> >
>      >> >> > _______________________________________________
>      >> >> > postgis-users mailing list
>      >> >> > postgis-users at postgis.refractions.net
>     <mailto: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 <tel:530-752-8380>
>      >> >> bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>
>      >> >> _______________________________________________
>      >> >> postgis-users mailing list
>      >> >> postgis-users at postgis.refractions.net
>     <mailto:postgis-users at postgis.refractions.net>
>      >> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
>      >> >
>      >> >
>      >> >
>      >> > _______________________________________________
>      >> > postgis-users mailing list
>      >> > postgis-users at postgis.refractions.net
>     <mailto: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 <tel:530-752-8380>
>      >> bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>
>      >> _______________________________________________
>      >> postgis-users mailing list
>      >> postgis-users at postgis.refractions.net
>     <mailto:postgis-users at postgis.refractions.net>
>      >> http://postgis.refractions.net/mailman/listinfo/postgis-users
>      >
>      >
>      >
>      > _______________________________________________
>      > postgis-users mailing list
>      > postgis-users at postgis.refractions.net
>     <mailto: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 <tel:530-752-8380>
>     bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>
>     _______________________________________________
>     postgis-users mailing list
>     postgis-users at postgis.refractions.net
>     <mailto:postgis-users at postgis.refractions.net>
>     http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users