[Gdal-dev] 2004 Tiger with new PostGIS

[Frank Warmerdam]

On Mon, 14 Feb 2005 10:45:39 -0800, David Blasby <dblasby at gmail.com> wrote:
> I'm trying to load the new Tiger data into Postgis, and I'm having troubles.
> 
> I solved the "constraints" on tables problem - just run the CREATE
> FUNCTION statement below - it replaces the addgeometrycolumn function
> so that it doesnt add constaints.  Hacky, but it works.
> 
> The second problem is with OGR - the altNames table isn't correctly
> forming arrays:
> 
> LOG:  statement: INSERT INTO "altname" ("module", "tlid", "rtsq",
> "feat") VALUES ('TGR11001', 76224848, 1, '{696,702')

Dave,

An error was recently identified with the logic that was trimming
field values that were too long.  It wasn't working properly for
array fields.  This problem is now fixed in CVS, so you should
be able to upgrade to a nightly snapshot (of GDAL). 

I'm still not sure what I'm going to do about the constraint problem
though.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent