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