<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16762" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV dir=ltr align=left><SPAN class=875292323-18122008><FONT face=Arial
color=#0000ff size=2>Hmm it appears it got stripped. You can download from
here.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=875292323-18122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=875292323-18122008><FONT face=Arial
color=#0000ff size=2><A
href="http://www.bostongis.com/downloads/pgutils/pgsql2shp136patched.zip">http://www.bostongis.com/downloads/pgutils/pgsql2shp136patched.zip</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=875292323-18122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=875292323-18122008><FONT face=Arial
color=#0000ff size=2>Anyrate let me know if it fixes your Vista problem.
It also automatically creates a .prj file. If you can test that out that
would be great too.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=875292323-18122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=875292323-18122008><FONT face=Arial
color=#0000ff size=2>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=875292323-18122008><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=875292323-18122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=875292323-18122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Paragon Corporation<BR><B>Sent:</B> Thursday, December 18, 2008 5:50
PM<BR><B>To:</B> 'PostGIS Users Discussion'<BR><B>Subject:</B> RE:
[postgis-users] pgsql2shp.exe fails with Windows Vista<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=734114422-18122008><FONT face=Arial
color=#0000ff size=2>Dan,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=734114422-18122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=734114422-18122008><FONT face=Arial
color=#0000ff size=2>Can you try this 1.3.6 patched version for me and see if it
works. I tried this on my Windows Xp and Windows Vista boxes and it worked
fine on both. If it works okay for you and verified it doesn't mess any
Linux user up, then I'll commit to 1.3 branch.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=734114422-18122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=734114422-18122008><FONT face=Arial
color=#0000ff size=2>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=734114422-18122008><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=734114422-18122008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Dan
Blomberg<BR><B>Sent:</B> Tuesday, December 16, 2008 10:13 PM<BR><B>To:</B>
PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users] pgsql2shp.exe
fails with Windows Vista<BR></FONT><BR></DIV>
<DIV></DIV>I am running it with commands. This is what I'm
running:<BR><BR>"c:\Program Files\PostgreSQL\8.3\bin>
<DIV class="ArwC7c ckChnd" id=:8b><WBR>pgsql2shp.exe -f contours.shp -u postgres
postgis contours<BR>Initializing... Done (postgis major version: 1).<BR>Output
shape: PolyLine<BR>Dumping: X"<BR><BR>It crashes at the X and does exactly what
Regina is saying (those three files empty). The same command works fine on
XP.<BR><BR>Dan<BR></DIV><BR>Paragon Corporation wrote:
<BLOCKQUOTE cite=mid:0FB76F04CCBF4CDE87C2DB0C14791BE4@H type="cite"><PRE wrap="">I mean XP and 2000 boxes all works fine. Vista is broken for pgsql2shp but
works fine for psql and shp2pgsql.
It couldn't be some dumb thing like because I presume psql was compiled with
VC++ and pgsql2shp I presume was compiled with MingW? (all are stack builder
installs at anyrate)
-----Original Message-----
From: Paragon Corporation [<A class=moz-txt-link-freetext href="mailto:lr@pcorp.us">mailto:lr@pcorp.us</A>]
Sent: Tuesday, December 16, 2008 9:48 PM
To: 'PostGIS Users Discussion'
Subject: RE: [postgis-users] pgsql2shp.exe fails with Windows Vista
Mark,
I was running it with command line options to output the file.
Without options it works fine.
It gets as far as creating the .shp, .dbf, .shx before it crashes. All 3
files are pretty empty except some weird header gobbly gook so I guess its
when its getting into the loop to start reading the data so you could be
right about the libpq.
Though if libpq were the problem, wouldn't I have the same issue running
psql and psql works fine.
As a side note -- shp2pgsql works fine though that doesn't depend on libpq
anyway.
Not sure it matters, but I don't actually have PostgreSQL installed on my
Vista, so I'm just running from a folder with psql, pg_dump, libpq etc and
all the dependency files in the folder, which works perfectly fine on my XP
and Vista boxes.
Thanks,
Regina
-----Original Message-----
From: <A class=moz-txt-link-abbreviated href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</A>
[<A class=moz-txt-link-freetext href="mailto:postgis-users-bounces@postgis.refractions.net">mailto:postgis-users-bounces@postgis.refractions.net</A>] On Behalf Of Mark
Cave-Ayland
Sent: Tuesday, December 16, 2008 7:08 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] pgsql2shp.exe fails with Windows Vista
Paragon Corporation wrote:
</PRE>
<BLOCKQUOTE type="cite"><PRE wrap="">Oops sent too quickly. Gives
Unhandled exception at 0x76f8814c in pgsql2shp.exe: 0xC0000005: Access
violation reading location 0x01ce2882.
Unfortunately I'm not good at debugging c code. Mark does the above
message mean anything to you.
</PRE></BLOCKQUOTE><PRE wrap=""><!---->
Only that pgsql2shp is trying to do something that Vista doesn't like?
Could it be related to pgsql2shp trying to locate libpq.dll? I guess this is
just running pgsql2shp without any additional command line options?
</PRE>
<BLOCKQUOTE type="cite"><PRE wrap="">In VS 2008 - just tells me binary not built with debug info.
</PRE></BLOCKQUOTE><PRE wrap=""><!---->
That's correct, the installer versions are stripped to remove the debug to
keep the sizes down. I have the original unstripped versions here, but I'm
fairly certain that gdb/MSVC have different debug info formats.
Hence if you want to debug, you'll need these unstripped versions and a copy
of MSYS/gdb on your Vista box to get a backtrace.
ATB,
Mark.
--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts <A class=moz-txt-link-freetext href="http://www.siriusit.co.uk">http://www.siriusit.co.uk</A>
T: +44 870 608 0063
_______________________________________________
postgis-users mailing list
<A class=moz-txt-link-abbreviated href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>
<A class=moz-txt-link-freetext href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A>
_______________________________________________
postgis-users mailing list
<A class=moz-txt-link-abbreviated href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>
<A class=moz-txt-link-freetext href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A>
</PRE></BLOCKQUOTE></BODY></HTML>