Ok, just checking.
http://svn.osgeo.org/postgis/trunk/extras/tiger_geocoder/tiger_2010/
Looks like something like this might do it:
cd /usr/share/postgresql/contrib
# edit create_geocode.sh
# then run it
./create_geocode.sh
or just load them from here:
http://svn.osgeo.org/postgis/trunk/extras
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 p
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
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,
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, A
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
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 Sa
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 ign
