[postgis-users] TIGER geocoder, Ticket #1838 (new defect)

[James Marca]

...
> 
> I think the issue is tiger_staging.ca_tabblock.gid is
> character_varying(16), while tiger.tabblock.tabblock_id is character
> varying(15).  There are 343 entries in tiger_staging.ca_tabblock with
> gid length of 16, all the rest are 15.
> 
> Is it okay to just change tabblock_id to varchar(16)?

I also needed to 

    ALTER TABLE tiger.tabblock ALTER COLUMN name TYPE character
    varying(11);

Apparently those two changes were enough to allow tabblock to load.
Running the rest of the script now.

Regards, 

James
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120813/c1384c00/attachment.pgp>