Re: [postgis-users] pgsql2shp fails
Thanks! It works fine now. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] pgsql2shp fails
Denis Rykov wrote: Result of \d public.results in psql: Table public.results Column | Type | Modifiers --+---+--- the_geom | geometry | reg | character(16) | Thanks for the bug report - should be fixed in latest SVN. Can you do an svn up and confirm that it now works for you? Many thanks, 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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] pgsql2shp fails
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 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] pgsql2shp fails
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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users