... > > 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
pgpVAFYzCeKdn.pgp
Description: PGP signature
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users