[postgis-tickets] [PostGIS] #2870: Binary insert into geography column results in value being inserted as geometry.

PostGIS trac at osgeo.org
Tue Aug 5 15:35:17 PDT 2014


#2870: Binary insert into geography column results in value being inserted as
geometry.
------------------------+---------------------------------------------------
 Reporter:  andrewdone  |       Owner:  pramsey      
     Type:  defect      |      Status:  new          
 Priority:  medium      |   Milestone:  PostGIS 2.1.4
Component:  postgis     |     Version:  2.1.x        
 Keywords:              |  
------------------------+---------------------------------------------------

Comment(by pramsey):

 Doing it by hand doesn't cause the problem
 {{{
 create table px (id SERIAL PRIMARY KEY, pt GEOGRAPHY(Point, 4326));
 insert into px(pt) values(ST_GeographyFromText('SRID=4326;Point(151.215289
 -33.856885)'));
 insert into px(pt) values
 ('0101000020E610000009C6C1A5E3E662406BB75D68AEED40C0');
 select id, pt, ST_Summary(pt) from px;
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2870#comment:5>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-tickets mailing list