Thanks Gregory, i will look into it tomorrow. (im not at the office) So your master makes you say things?
Thanks again everyone. On Thu, May 15, 2008 at 12:13 AM, Gregory Williamson < [EMAIL PROTECTED]> wrote: > > Sanity ? > > ;-) > > Empty fields or misformed SQL, missing data or misformed data. Depending on > how you are setting the output, you can try running sample statements in the > "psql" tool (or pgAdmin): > BEGIN; > <your sql here>; > ROLLBACK; -- assuming you don't want partial changes > > Post back the first few lines and maybe the last few, but do eyeball it > first and see if anything jumps out at you. > > Sorry for top-posting with such a slug o'text below but, as they say, "ours > is not to reason why, but to invert and multiply." > > Greg Williamson > Senior DBA > DigitalGlobe > > Confidentiality Notice: This e-mail message, including any attachments, is > for the sole use of the intended recipient(s) and may contain confidential > and privileged information and must be protected in accordance with those > provisions. Any unauthorized review, use, disclosure or distribution is > prohibited. If you are not the intended recipient, please contact the sender > by reply e-mail and destroy all copies of the original message. > > (My corporate masters made me say this.) > > > > -----Original Message----- > From: [EMAIL PROTECTED] on behalf of George > Silva > Sent: Wed 5/14/2008 8:03 PM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] Having problemas to convert SHP to PGSQL > > Thanks Robert. Will try that. > > What should i look for? > > George > > > On Wed, May 14, 2008 at 3:45 PM, Burgholzer,Robert < > [EMAIL PROTECTED]> wrote: > > > BTW - I always dump the output of shp2pgsql to a text file, so that > I can look at the SQL insert statements if there is a problem. > > > Robert W. Burgholzer > Surface Water Modeler > Office of Water Supply and Planning > Virginia Department of Environmental Quality > [EMAIL PROTECTED] > 804-698-4405 > Open Source Modeling Tools: > http://sourceforge.net/projects/npsource/ > > -----Original Message----- > > From: [EMAIL PROTECTED] [ > mailto:[EMAIL PROTECTED]<[EMAIL PROTECTED]>] > On Behalf Of Burgholzer,Robert > Sent: Wednesday, May 14, 2008 2:36 PM > To: PostGIS Users Discussion > > Subject: RE: [postgis-users] Having problemas to convert SHP to > PGSQL > > Syntax for command please ... > > Robert W. Burgholzer > Surface Water Modeler > Office of Water Supply and Planning > Virginia Department of Environmental Quality > [EMAIL PROTECTED] > 804-698-4405 > Open Source Modeling Tools: > http://sourceforge.net/projects/npsource/ > > -----Original Message----- > From: [EMAIL PROTECTED] [ > mailto:[EMAIL PROTECTED]<[EMAIL PROTECTED]>] > On Behalf Of George R. C. Silva > Sent: Wednesday, May 14, 2008 2:27 PM > To: PostGIS Users Discussion > Subject: [postgis-users] Having problemas to convert SHP to PGSQL > > hello all! > > Once again i come with a issue for you the experts :P > > I´m having trouble converting a shapefile to postgis schema, and > nothing > will make it work. > > the shp2pgsql actually runs, but at the end, no table is added or > populated. I even tried converting using QGIS 10 > > I will attach a zip of the shpfile. SRID is 29182. > > Ive checked within ArcGIS is the shp is valid, or has problems, and > nothing. > > My postgresql is 8.3 and latest pgis. > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users