[postgis-devel] geocoder rev 7531

[Paragon Corporation]

Brian,
Does your log show anything?  I just revised to force Unix line breaks and
also got rid of the  CREATE index call at the end which might have been
causing problems.

Unfortunately not near a Linux machine at moment so can't test.

You can also remark out the line that reruns the tiger_loader.sql ..  I
haven't changed that in a while.

Thanks,
Regina 

-----Original Message-----
From: postgis-devel-bounces at postgis.refractions.net
[mailto:postgis-devel-bounces at postgis.refractions.net] On Behalf Of
maplabs at light42.com
Sent: Friday, July 01, 2011 12:13 AM
To: postgis-devel at postgis.refractions.net
Subject: [postgis-devel] geocoder rev 7531

upgrade_geocode.sql   hung .. idle in transaction...  ??
psql (9.0.4)
 POSTGIS="1.5.2" GEOS="3.3.0-CAPI-1.7.0" PROJ="Rel. 4.7.1, 23 September
2009" LIBXML="2.7.6" USE_STATS

==
/home/shared/srcs_ras/postgis_trunk/extras/tiger_geocoder/tiger_2010$
psql geocoder -f tiger_loader.sql
SET
BEGIN
DROP AGGREGATE
CREATE AGGREGATE
CREATE FUNCTION
DROP TABLE
psql:tiger_loader.sql:38: NOTICE:  CREATE TABLE / PRIMARY KEY will create
implicit index "loader_platform_pkey" for table "loader_platform"
CREATE TABLE
INSERT 0 1
INSERT 0 1
DROP TABLE
psql:tiger_loader.sql:92: NOTICE:  CREATE TABLE / PRIMARY KEY will create
implicit index "loader_variables_pkey" for table "loader_variables"
CREATE TABLE
INSERT 0 1
DROP TABLE
psql:tiger_loader.sql:105: NOTICE:  CREATE TABLE / PRIMARY KEY will create
implicit index "loader_lookuptables_pkey" for table "loader_lookuptables"
CREATE TABLE
COMMENT
COMMENT
COMMENT
COMMENT
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
COMMIT
dbb at ra-server:/home/shared/srcs_ras/postgis_trunk/extras/tiger_geocoder/tige
r_2010$ psql geocoder -f upgrade_geocode.sql SET

>>>>>> does not complete... 


_______________________________________________
postgis-devel mailing list
postgis-devel at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-devel