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 <wood...@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 >> <wood...@swoodbridge.com >> <mailto:woodbri@swoodbridge.**com<wood...@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 >> <bkp...@ucdavis.edu <mailto:bkp...@ucdavis.edu> >> <mailto:bkp...@ucdavis.edu <mailto:bkp...@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 >> <a...@arencambre.com <mailto:a...@arencambre.com> >> <mailto:a...@arencambre.com <mailto:a...@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 >> <bkp...@ucdavis.edu <mailto:bkp...@ucdavis.edu> >> <mailto:bkp...@ucdavis.edu <mailto:bkp...@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 >> <a...@arencambre.com <mailto:a...@arencambre.com> >> <mailto:a...@arencambre.com <mailto:a...@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 >> <bkp...@ucdavis.edu <mailto:bkp...@ucdavis.edu> >> <mailto:bkp...@ucdavis.edu <mailto:bkp...@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 >> <a...@arencambre.com <mailto:a...@arencambre.com> >> <mailto:a...@arencambre.com <mailto:a...@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@postgis. refractions.net >> >> <mailto:postgis-users@postgis.**refractions.net<postgis-users@postgis.refractions.net> >> > >> <mailto:postgis-users@postgis. refractions.net >> >> <mailto:postgis-users@postgis.**refractions.net<postgis-users@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>> >> >> >> bkp...@ucdavis.edu <mailto:bkp...@ucdavis.edu> >> <mailto:bkp...@ucdavis.edu <mailto:bkp...@ucdavis.edu>> >> >> >> >> ______________________________ _________________ >> >> >> postgis-users mailing list >> >> >> postgis-users@postgis. refractions.net >> >> <mailto:postgis-users@postgis.**refractions.net<postgis-users@postgis.refractions.net> >> > >> <mailto:postgis-users@postgis. refractions.net >> >> <mailto:postgis-users@postgis.**refractions.net<postgis-users@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@postgis. refractions.net >> >> <mailto:postgis-users@postgis.**refractions.net<postgis-users@postgis.refractions.net> >> > >> <mailto:postgis-users@postgis. refractions.net >> >> <mailto:postgis-users@postgis.**refractions.net<postgis-users@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>> >> >> bkp...@ucdavis.edu <mailto:bkp...@ucdavis.edu> >> <mailto:bkp...@ucdavis.edu <mailto:bkp...@ucdavis.edu>> >> >> >> ______________________________ _________________ >> >> postgis-users mailing list >> >> postgis-users@postgis. refractions.net >> >> <mailto:postgis-users@postgis.**refractions.net<postgis-users@postgis.refractions.net> >> > >> <mailto:postgis-users@postgis. refractions.net >> >> <mailto:postgis-users@postgis.**refractions.net<postgis-users@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@postgis. refractions.net >> >> <mailto:postgis-users@postgis.**refractions.net<postgis-users@postgis.refractions.net> >> > >> <mailto:postgis-users@postgis. refractions.net >> >> <mailto:postgis-users@postgis.**refractions.net<postgis-users@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>> >> bkp...@ucdavis.edu <mailto:bkp...@ucdavis.edu> >> <mailto:bkp...@ucdavis.edu <mailto:bkp...@ucdavis.edu>> >> >> ______________________________ _________________ >> postgis-users mailing list >> postgis-users@postgis. refractions.net >> >> <mailto:postgis-users@postgis.**refractions.net<postgis-users@postgis.refractions.net> >> > >> <mailto:postgis-users@postgis. refractions.net >> >> <mailto:postgis-users@postgis.**refractions.net<postgis-users@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@postgis. refractions.net >> >> <mailto:postgis-users@postgis.**refractions.net<postgis-users@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@postgis. refractions.net >> >> <mailto:postgis-users@postgis.**refractions.net<postgis-users@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@postgis.**refractions.net<postgis-users@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@postgis.**refractions.net<postgis-users@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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
