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>> 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>> 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>> 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>> 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>> 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
<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.
>> >> >
>> >> > 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@postgis.refractions.net
<mailto:postgis-users@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>
>> >> bkp...@ucdavis.edu <mailto:bkp...@ucdavis.edu>
>> >> _______________________________________________
>> >> postgis-users mailing list
>> >> postgis-users@postgis.refractions.net
<mailto:postgis-users@postgis.refractions.net>
>> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
>> >
>> >
>> >
>> > _______________________________________________
>> > postgis-users mailing list
>> > postgis-users@postgis.refractions.net
<mailto:postgis-users@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>
>> bkp...@ucdavis.edu <mailto:bkp...@ucdavis.edu>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users@postgis.refractions.net
<mailto:postgis-users@postgis.refractions.net>
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
<mailto:postgis-users@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>
bkp...@ucdavis.edu <mailto:bkp...@ucdavis.edu>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
<mailto:postgis-users@postgis.refractions.net>
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
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
