[postgis-users] Problem with PostGIS 1.0.0 RC1
Mark Cave-Ayland
m.cave-ayland at webbased.co.uk
Sat Jan 22 05:12:48 PST 2005
Hi strk,
Sorry, it looks like the WKB got mangled when I was cutting and pasting into
my email :( Here is the actual geometry pasted correctly from Danny's
original email, and here are the results I am getting back:
For PostGIS 0.9.1:
[pg80b2 at ralph pg80b2]$ psql -d postgis091 -p 5433
Welcome to psql 8.0.0rc1, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
postgis091=# select postgis_version();
postgis_version
---------------------------------------
0.9 USE_GEOS=0 USE_PROJ=0 USE_STATS=1
(1 row)
postgis091=# select
GeomFromWKB('010300000001000000050000003A6484B530A012418C2BD617CF7C48413A648
4B520A112418C2BD617CF7C48413A6484B520A112418C2BD617ED7C48413A6484B530A012418
C2BD617ED7C48413A6484B530A012418C2BD617CF7C4841');
geomfromwkb
----------------------------------------------------------------------------
----------------------------------------------------------------------------
-------------------------------------
SRID=0;POLYGON((305164.177262846 3209630.18622345,305224.177262846
3209630.18622345,305224.177262846 3209690.18622345,305164.177262846
3209690.18622345,305164.177262846 3209630.18622345))
(1 row)
postgis091=#
For PostGIS 1.0-rc1:
[pg80b2 at ralph pg80b2]$ psql -d mca1 -p 5433
Welcome to psql 8.0.0rc1, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
mca1=# select postgis_version();
postgis_version
---------------------------------------
1.0 USE_GEOS=0 USE_PROJ=0 USE_STATS=1
(1 row)
mca1=# select
GeomFromWKB('010300000001000000050000003A6484B530A012418C2BD617CF7C48413A648
4B520A112418C2BD617CF7C48413A6484B520A112418C2BD617ED7C48413A6484B530A012418
C2BD617ED7C48413A6484B530A012418C2BD617CF7C4841');
ERROR: parse error - invalid geometry
mca1=#
Kind regards,
Mark.
------------------------
WebBased Ltd
South West Technology Centre
Tamar Science Park
Plymouth
PL6 8BT
T: +44 (0)1752 791021
F: +44 (0)1752 791023
W: http://www.webbased.co.uk
More information about the postgis-users
mailing list