[postgis-users] TIGER geocoder, Ticket #1838 (new defect)
James Marca
jmarca at translab.its.uci.edu
Mon Aug 13 13:12:09 PDT 2012
...
>
> 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>
More information about the postgis-users
mailing list