[postgis-users] pgsql2shp.exe fails with Windows Vista

[Paragon Corporation]

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 [mailto:lr at pcorp.us] 
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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] 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:

> 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.

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?

> In VS 2008 - just tells me binary not built with debug info.

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 http://www.siriusit.co.uk
T: +44 870 608 0063
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users