[postgis-users] Geocoder 2010, Pg 9, PostGIS 1.5

[maplabs at light42.com]

  I tried hooking up the Geocoder for TIGER 2010 as found in postgis_trunk
but it is failing.. First try was using PostGIS 2.0 trunk, after 
problems next was 
with PostGIS 1.5.. both with Postgresql 9.0 under linux

  It seems if I add the schema tiger_data to search_path 
then run create_geocode.sql again manually, it gets a little
further.. but still, I end up with a database that looks like this:

                             List of relations
 Schema |         Name          |   Type   | Owner |   
 Size    | Description 
--------+-----------------------+----------+-------+------------+-------------
 public | geography_columns     | view     | dbb   | 0 bytes    | 
 public | geometry_columns      | table    | dbb   | 0 bytes    | 
 public | spatial_ref_sys       | table    | dbb   | 0 bytes    | 
 tiger  | addr                  | table    | dbb   | 0 
bytes    | 
 tiger  | addr_gid_seq          | sequence | dbb   | 8192 bytes | 
 tiger  | county                | table    | dbb   | 0 
bytes    | 
 tiger  | county_gid_seq        | sequence | dbb   | 8192 bytes | 
 tiger  | county_lookup         | table    | dbb   | 0 bytes    | 
 tiger  | countysub_lookup      | table    | dbb   | 0 bytes    | 
 tiger  | cousub                | table    | dbb   | 0 
bytes    | 
 tiger  | cousub_gid_seq        | sequence | dbb   | 8192 bytes | 
 tiger  | direction_lookup      | table    | dbb   | 8192 bytes | 
 tiger  | edges                 | table    | dbb   | 0 
bytes    | 
 tiger  | edges_gid_seq         | sequence | dbb   | 8192 bytes | 
 tiger  | faces                 | table    | dbb   | 0 
bytes    | 
 tiger  | faces_gid_seq         | sequence | dbb   | 8192 bytes | 
 tiger  | featnames             | table    | dbb   | 0 bytes 
   | 
 tiger  | featnames_gid_seq     | sequence | dbb   | 8192 bytes | 
 tiger  | loader_lookuptables   | table    | dbb   | 16 kB      | 
 tiger  | loader_platform       | table    | dbb   | 8192 bytes | 
 tiger  | loader_variables      | table    | dbb   | 8192 bytes | 
 tiger  | place                 | table    | dbb   | 0 
bytes    | 
 tiger  | place_gid_seq         | sequence | dbb   | 8192 bytes | 
 tiger  | place_lookup          | table    | dbb   | 0 bytes 
   | 
 tiger  | secondary_unit_lookup | table    | dbb   | 8192 bytes | 
 tiger  | state                 | table    | dbb   | 0 
bytes    | 
 tiger  | state_gid_seq         | sequence | dbb   | 8192 bytes | 
 tiger  | state_lookup          | table    | dbb   | 8192 bytes | 
 tiger  | county_lookup         | table    | dbb   | 0 bytes    | 
 tiger  | countysub_lookup      | table    | dbb   | 0 bytes    | 
 tiger  | cousub                | table    | dbb   | 0 
bytes    | 
 tiger  | cousub_gid_seq        | sequence | dbb   | 8192 bytes | 
 tiger  | direction_lookup      | table    | dbb   | 8192 bytes | 
 tiger  | edges                 | table    | dbb   | 0 
bytes    | 
 tiger  | edges_gid_seq         | sequence | dbb   | 8192 bytes | 
 tiger  | faces                 | table    | dbb   | 0 
bytes    | 
 tiger  | faces_gid_seq         | sequence | dbb   | 8192 bytes | 
 tiger  | featnames             | table    | dbb   | 0 bytes 
   | 
 tiger  | featnames_gid_seq     | sequence | dbb   | 8192 bytes | 
 tiger  | loader_lookuptables   | table    | dbb   | 16 kB      | 
 tiger  | loader_platform       | table    | dbb   | 8192 bytes | 
 tiger  | loader_variables      | table    | dbb   | 8192 bytes | 
 tiger  | place                 | table    | dbb   | 0 
bytes    | 
 tiger  | place_gid_seq         | sequence | dbb   | 8192 bytes | 
 tiger  | place_lookup          | table    | dbb   | 0 bytes 
   | 
 tiger  | secondary_unit_lookup | table    | dbb   | 8192 bytes | 
 tiger  | state                 | table    | dbb   | 0 
bytes    | 
 tiger  | state_gid_seq         | sequence | dbb   | 8192 bytes | 
 tiger  | state_lookup          | table    | dbb   | 8192 bytes | 
 tiger  | street_type_lookup    | table    | dbb   | 24 kB      | 
 tiger  | zcta500               | table    | dbb   | 0 
bytes    | 
 tiger  | zcta500_gid_seq       | sequence | dbb   | 8192 bytes | 
 tiger  | zip_lookup            | table    | dbb   | 0 bytes 
   | 
 tiger  | zip_lookup_all        | table    | dbb   | 0 bytes    | 
 tiger  | zip_lookup_base       | table    | dbb   | 0 bytes    | 
 tiger  | zip_state             | table    | dbb   | 0 bytes 
   | 
 tiger  | zip_state_loc         | table    | dbb   | 0 bytes    |