[postgis-devel] geocoder rev 7531

[maplabs at light42.com]

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/tiger_2010$ psql geocoder -f 
upgrade_geocode.sql
SET

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