[Gdal-dev] 2004 Tiger with new PostGIS

[David Blasby]

okay - using the CVS version solved my problem.

So,
1. use CVS version
2. use the AddGeometryColumns function I sent earlier today
3.  ogr2ogr -f PostgreSQL PG:dbname=tiger_test .

Thanks, frank!

dave


On Mon, 14 Feb 2005 13:55:54 -0500, Frank Warmerdam
<fwarmerdam at gmail.com> wrote:
> 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
>