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> 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> 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> 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>
> 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>
> 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>
> >> >> 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
> >> >> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >> >> >
> >> >>
> >> >>
> >> >>
> >> >> --
> >> >> Bborie Park
> >> >> Programmer
> >> >> Center for Vectorborne Diseases
> >> >> UC Davis
> >> >> 530-752-8380
> >> >> bkp...@ucdavis.edu
> >> >> _______________________________________________
> >> >> 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
> >> >
> >>
> >>
> >>
> >> --
> >> Bborie Park
> >> Programmer
> >> Center for Vectorborne Diseases
> >> UC Davis
> >> 530-752-8380
> >> bkp...@ucdavis.edu
> >> _______________________________________________
> >> 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
> >
>
>
>
> --
> Bborie Park
> Programmer
> Center for Vectorborne Diseases
> UC Davis
> 530-752-8380
> bkp...@ucdavis.edu
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
postgres@aren-VirtualBox:/usr/share/postgresql/9.1/contrib/postgis-2.0$
/usr/bin/psql -d spatial_db_template -f
/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql >
/var/lib/postgresql/out.txt
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:763:
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"spatial_ref_sys_pkey" for table "spatial_ref_sys"
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4041:
NOTICE: aggregate memgeomunion(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4042:
NOTICE: aggregate geomunion(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4043:
NOTICE: aggregate st_geomunion(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4044:
NOTICE: aggregate accum_old(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4045:
NOTICE: aggregate st_accum_old(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4046:
NOTICE: function
addgeometrycolumn(pg_catalog.varchar,pg_catalog.varchar,pg_catalog.varchar,pg_catalog.varchar,pg_catalog.int4,pg_catalog.varchar,pg_catalog.int4)
does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4047:
NOTICE: function
addgeometrycolumn(pg_catalog.varchar,pg_catalog.varchar,pg_catalog.varchar,pg_catalog.int4,pg_catalog.varchar,pg_catalog.int4)
does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4048:
NOTICE: function
addgeometrycolumn(pg_catalog.varchar,pg_catalog.varchar,pg_catalog.int4,pg_catalog.varchar,pg_catalog.int4)
does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4049:
NOTICE: function populate_geometry_columns() does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4050:
NOTICE: function populate_geometry_columns(oid) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4051:
NOTICE: function box2d_overleft(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4052:
NOTICE: function box2d_overright(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4053:
NOTICE: function box2d_left(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4054:
NOTICE: function box2d_right(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4055:
NOTICE: function box2d_contain(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4056:
NOTICE: function box2d_contained(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4057:
NOTICE: function box2d_overlap(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4058:
NOTICE: function box2d_same(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4059:
NOTICE: function box2d_intersects(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4060:
NOTICE: function st_area(geography) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4061:
NOTICE: function st_asx3d(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4062:
NOTICE: function st_box2d_overleft(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4063:
NOTICE: function st_box2d_overright(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4064:
NOTICE: function st_box2d_left(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4065:
NOTICE: function st_box2d_right(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4066:
NOTICE: function st_box2d_contain(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4067:
NOTICE: function st_box2d_contained(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4068:
NOTICE: function st_box2d_overlap(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4069:
NOTICE: function st_box2d_same(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4070:
NOTICE: function st_box2d_intersects(box2d,box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4071:
NOTICE: function st_box2d_in(cstring) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4072:
NOTICE: function st_box2d_out(box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4073:
NOTICE: function st_box2d(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4074:
NOTICE: function st_box2d(box3d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4075:
NOTICE: function st_box3d(box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4076:
NOTICE: function st_box(box3d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4077:
NOTICE: function st_box3d(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4078:
NOTICE: function st_box(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4079:
NOTICE: function st_concavehull(geometry,pg_catalog.float8) does not exist,
skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4080:
NOTICE: function st_text(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4081:
NOTICE: function st_geometry(box2d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4082:
NOTICE: function st_geometry(box3d) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4083:
NOTICE: function st_geometry(text) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4084:
NOTICE: function st_geometry(bytea) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4085:
NOTICE: function st_bytea(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4086:
NOTICE: function st_addbbox(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4087:
NOTICE: function st_dropbbox(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4088:
NOTICE: function st_hasbbox(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4089:
NOTICE: function cache_bbox() does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4090:
NOTICE: function st_cache_bbox() does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4091:
NOTICE: function st_length(geography) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4092:
NOTICE: function st_perimeter(geography) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4093:
NOTICE: function transform_geometry(geometry,text,text,pg_catalog.int4) does
not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4094:
NOTICE: function collector(geometry,geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4095:
NOTICE: function st_collector(geometry,geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4096:
NOTICE: function geom_accum(geometry[],geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4097:
NOTICE: function st_geom_accum(geometry[],geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4098:
NOTICE: function collect_garray(geometry[]) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4099:
NOTICE: function st_collect_garray(geometry[]) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4100:
NOTICE: function geosnoop(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4101:
NOTICE: function jtsnoop(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4102:
NOTICE: function st_noop(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4103:
NOTICE: function st_max_distance(geometry,geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4104:
NOTICE: function st_minimumboundingcircle(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4105:
NOTICE: function st_geometry_analyze(internal) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4106:
NOTICE: function st_geometry_in(cstring) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4107:
NOTICE: function st_geometry_out(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4108:
NOTICE: function st_geometry_recv(internal) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4109:
NOTICE: function st_geometry_send(geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4110:
NOTICE: function st_spheroid_in(cstring) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4111:
NOTICE: function st_spheroid_out(spheroid) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4112:
NOTICE: function st_geometry_lt(geometry,geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4113:
NOTICE: function st_geometry_gt(geometry,geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4114:
NOTICE: function st_geometry_ge(geometry,geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4115:
NOTICE: function st_geometry_eq(geometry,geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4116:
NOTICE: function st_geometry_cmp(geometry,geometry) does not exist, skipping
psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis_upgrade_20_minor.sql:4117:
NOTICE: function snaptogrid(geometry,float8,float8) does not exist, skipping
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
