Which version of shp2pgsql are you using (or what is the date on it). (HINT HINT Paul: Would be nice for the dumper/loader files to have a version option similar to what mapserv has that gives a clue the pedigree. )
Also can you provide a snippet of the file or if a small file the whole file. I just tried a sample dump of one of mine with your arguments and it dumps out the attached. You can try loading my sample and if it gives the same error, you might be missing some overloader casts in your database. Hope that Helps, Regina ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jessica Fendos Sent: Friday, April 11, 2008 10:46 AM To: [email protected] Subject: RE: [postgis-users] Upload Table Warning Message I did the following: shp2pgsql (path_to_shapefile).shp tabename > namedsql.sql psql -h XXX -U XXX -d XXX -f namedsql.sql J >>> [EMAIL PROTECTED] 4/11/2008 9:03 AM >>> How did you generate the sql file. Was it dump of a table from 8.0? Can you post a snippet of the sql file? Thanks, Regina ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jessica Fendos Sent: Friday, April 11, 2008 9:55 AM To: [email protected] Subject: [postgis-users] Upload Table Warning Message Hi list: I uploaded a table using psql command to both Postgres 8.0 and 8.2. The upload to 8.2 (with a newer version of PostGIS), I got a warning message: INSERT 01 psql:XXXX.sql :01: WARNING: OGC WKT expected, EWKT provided - use GeomFromEWKT <> for this .... What does this mean and how can I avoid this? Thank you for your advice. Jessica ________________________________ The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer. ________________________________ Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
testcoll.sql
Description: testcoll.sql
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
