[postgis-users] How to update your SVN copy of PostGIS
Aren Cambre
aren at arencambre.com
Sat Dec 10 15:25:43 PST 2011
I refreshed the functions list and the parent DB and even opened/closed
pgAdmin III. :-)
I also ran this script:
*SELECT * FROM pg_proc proc JOIN pg_language lang*
*ON proc.prolang = lang.oid*
*ORDER BY proname;*
Double-checked myself with:
*SELECT * FROM pg_proc proc JOIN pg_language lang*
*ON proc.prolang = lang.oid*
*WHERE proname LIKE '%geocode%'*
*ORDER BY proname;*
Definitely no *geocode.** functions there.
Aren
On Sat, Dec 10, 2011 at 5:18 PM, Stephen Woodbridge <woodbri at swoodbridge.com
> wrote:
> 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<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<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<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<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<postgis-users at postgis.refractions.net>
>> >
>> <mailto:postgis-users at postgis. refractions.net
>> <mailto:postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> >>
>>
>> >> >> > http://postgis.refractions.
>> net/mailman/listinfo/postgis- users
>>
>> <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<postgis-users at postgis.refractions.net>
>> >
>> <mailto:postgis-users at postgis. refractions.net
>> <mailto:postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> >>
>>
>> >> >> http://postgis.refractions. net/mailman/listinfo/postgis-
>> users
>> <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<postgis-users at postgis.refractions.net>
>> >
>> <mailto:postgis-users at postgis. refractions.net
>> <mailto:postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> >>
>>
>> >> > http://postgis.refractions. net/mailman/listinfo/postgis-
>> users
>>
>> <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<postgis-users at postgis.refractions.net>
>> >
>> <mailto:postgis-users at postgis. refractions.net
>> <mailto:postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> >>
>>
>> >> http://postgis.refractions. net/mailman/listinfo/postgis-
>> users
>> <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<postgis-users at postgis.refractions.net>
>> >
>> <mailto:postgis-users at postgis. refractions.net
>> <mailto:postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> >>
>>
>> > http://postgis.refractions. net/mailman/listinfo/postgis-
>> users
>>
>> <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<postgis-users at postgis.refractions.net>
>> >
>> <mailto:postgis-users at postgis. refractions.net
>> <mailto:postgis-users at postgis.**refractions.net<postgis-users at postgis.refractions.net>
>> >>
>>
>> http://postgis.refractions. net/mailman/listinfo/postgis- users
>> <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<postgis-users at postgis.refractions.net>
>> >
>> http://postgis.refractions. net/mailman/listinfo/postgis- users
>> <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<postgis-users at postgis.refractions.net>
>> >
>> http://postgis.refractions. net/mailman/listinfo/postgis- users
>>
>> <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<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<postgis-users at postgis.refractions.net>
> http://postgis.refractions.**net/mailman/listinfo/postgis-**users<http://postgis.refractions.net/mailman/listinfo/postgis-users>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111210/eb545190/attachment.html>
More information about the postgis-users
mailing list