[postgis-users] Upload Table Warning Message

[Obe, Regina]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Jessica Fendos
Sent: Friday, April 11, 2008 10:46 AM
To: postgis-users at postgis.refractions.net
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

>>> robe.dnd at cityofboston.gov 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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Jessica Fendos
Sent: Friday, April 11, 2008 9:55 AM
To: postgis-users at postgis.refractions.net
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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: testcoll.sql
Type: application/octet-stream
Size: 20012 bytes
Desc: testcoll.sql
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080411/f79a851d/attachment.obj>