Hi,
It looks like you're having a little bit of trouble with the SQL. That is
understandable though, your problem is a little tricky, because it requires you
to nest a query.
You should first note that it is not possible to have two FROM statements in a
single query. Start by breaking down the
Hi,
Yes, there is a way to do this.
First, you have to create a 'sequence'. But you only have to do this once. It
won't really matter if several different tables are using the same sequence in
your situation.
create sequence sq; -- You only have to do this once. You could also make a
temporar
Hi,
I understand why would you be reluctant to do automatic correction. However,
the shapelib library, which shp2pgsql directly uses, does do automatic
correction.
I agree: any mistake in the dbf should be reported. However, I believe that, at
the very least, a switch should be supported that
Hi everybody,
This is my first post to the list. Please let me know (flame) if this is not a
suitable place to post.
If you use shp2pgsql to upload a shapefile with an attribute table that has a
malformed integer (like a letter), shp2pgsql will not correct it, and the
upload will fail.
Normal
