[postgis-users] pgsql2shp fails

[Mark Cave-Ayland]

Denis Rykov wrote:

> Hello, Regina. There is information about my system:
> 
> 1) RCSID: $Id: pgsql2shp-core.h 5646 2010-05-27 13:19:12Z pramsey $
> RELEASE: 2.0 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
> 2) pgsql2shp -f $dir_output/bounds/bnd-a-osm-buf.shp -U pgsql -d osm
> public.results
> 3) PostgreSQL 8.4
> 4) 2.0 r5830
> 5) FreeBSD 8.1
> 
> I get the following error: "Error executing main scan query: ERROR:
> column "gid" does not exist
> LINE 1: ... -1), 'NDR') AS _geoX FROM "public"."results" ORDER BY "gid""

That's probably my bug (although the other apparent bug is that I forgot 
to set the svn id property on pgsql2shp-core.h too).

What does the output of "\d public.results" look like in psql?


ATB,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs