[postgis-users] pgsql2shp fails

[Denis Rykov]

Result of \d public.results in psql:

       Table "public.results"
 Column  |     Type      | Modifiers
----------+---------------+-----------
the_geom | geometry      |
reg      | character(16) |

2010/8/27 Mark Cave-Ayland <mark.cave-ayland at siriusit.co.uk>:
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>