[Gdal-dev] ntf to postgres tables

[nida Khan]

Frank,

Thank you so much for your help, I really appreciate it :).

you r a star of this list!

kind Regards
Nida
xx

----- Original Message -----
From: "Frank Warmerdam" <warmerdam at pobox.com>
To: <gdal-dev at remotesensing.org>
Sent: Tuesday, December 17, 2002 5:06 PM
Subject: Re: [Gdal-dev] ntf to postgres tables


> nida Khan wrote:
> > good idea! it works wonders! :).
> >
> > I was able to import  all the files in the postgres, in that process I
found
> > a weired thing though.
> >
> > First time when I import into postgres it works fine, after that I drop
the
> > table and asso. seq. and repeat the process, this time it fails with
this
> > error
>
> Nida,
>
> I believe the problem is that though you dropped the table, the table
still
> appeared in the geometry_columns metadata table and thus an attempt to add
it
> again with the same name failed.  If you read the SQL docs you will see
> a DropGeometryColumn() function or something similar you can invoke to
> clean a value out of the geometry_columns table.
>
> Instead of dropping the table yourself, you can use the "OVERWRITE=YES"
layer
> creation option, and ogr2ogr will take care of getting rid of all aspects
of
> the old layer itself.
>
> Best regard,
>
> --
> ---------------------------------------+----------------------------------
----
> 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
>
>
> _______________________________________________
> Gdal-dev mailing list
> Gdal-dev at remotesensing.org
> http://remotesensing.org/mailman/listinfo/gdal-dev