[postgis-users] pgsql2shp fails

[Denis Rykov]

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