[postgis-users] How to update your SVN copy of PostGIS
Stephen Woodbridge
woodbri at swoodbridge.com
Sat Dec 10 15:18:35 PST 2011
Try right click on database and/or function list and refresh it.
On 12/10/2011 6:15 PM, Aren Cambre wrote:
> Thanks.
>
> Now here's what I don't get: where are the *geocode* and
> *geocode_intersection* functions? If I look at the functions list in
> *spatial_db_template*'s *public* schema (using pgAdmin III), should I
> see those two? I thought they were included in the base PostGIS 2.0 product?
>
> Aren
>
> On Sat, Dec 10, 2011 at 5:09 PM, Stephen Woodbridge
> <woodbri at swoodbridge.com <mailto:woodbri at swoodbridge.com>> wrote:
>
> 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>
> <mailto: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>
> <mailto: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>
> <mailto: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>
> <mailto: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>
> <mailto:bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>>> wrote:
> >> >>
> >> >> If you used something like...
> >> >>
> >> >> svn check out https://svn.osgeo.org/postgis/ trunk
> <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>
> <mailto: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
> <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
> <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>
> <mailto:postgis-users at postgis. refractions.net
> <mailto:postgis-users at postgis.refractions.net>>
>
> >> >> > http://postgis.refractions.
> net/mailman/listinfo/postgis- users
> <http://postgis.refractions.net/mailman/listinfo/postgis-users>
> >> >> >
> >> >>
> >> >>
> >> >>
> >> >> --
> >> >> Bborie Park
> >> >> Programmer
> >> >> Center for Vectorborne Diseases
> >> >> UC Davis
> >> >> 530-752-8380 <tel:530-752-8380> <tel:530-752-8380
> <tel:530-752-8380>>
> >> >> bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>
> <mailto: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>
> <mailto:postgis-users at postgis. refractions.net
> <mailto:postgis-users at postgis.refractions.net>>
>
> >> >> http://postgis.refractions. net/mailman/listinfo/postgis-
> users
> <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>
> <mailto:postgis-users at postgis. refractions.net
> <mailto:postgis-users at postgis.refractions.net>>
>
> >> > http://postgis.refractions. net/mailman/listinfo/postgis-
> users
> <http://postgis.refractions.net/mailman/listinfo/postgis-users>
> >> >
> >>
> >>
> >>
> >> --
> >> Bborie Park
> >> Programmer
> >> Center for Vectorborne Diseases
> >> UC Davis
> >> 530-752-8380 <tel:530-752-8380> <tel:530-752-8380
> <tel:530-752-8380>>
> >> bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>
> <mailto: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>
> <mailto:postgis-users at postgis. refractions.net
> <mailto:postgis-users at postgis.refractions.net>>
>
> >> http://postgis.refractions. net/mailman/listinfo/postgis-
> users
> <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>
> <mailto:postgis-users at postgis. refractions.net
> <mailto:postgis-users at postgis.refractions.net>>
>
> > http://postgis.refractions. net/mailman/listinfo/postgis-
> users
> <http://postgis.refractions.net/mailman/listinfo/postgis-users>
> >
>
>
>
> --
> Bborie Park
> Programmer
> Center for Vectorborne Diseases
> UC Davis
> 530-752-8380 <tel:530-752-8380> <tel:530-752-8380
> <tel:530-752-8380>>
> bkpark at ucdavis.edu <mailto:bkpark at ucdavis.edu>
> <mailto: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>
> <mailto:postgis-users at postgis. refractions.net
> <mailto:postgis-users at postgis.refractions.net>>
>
> http://postgis.refractions. net/mailman/listinfo/postgis- users
> <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
> <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
> <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
More information about the postgis-users
mailing list