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

[PostGIS]

#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 with prepared statements doesn't seem to cause problems either:
 {{{
 drop table px;
 create table px (id SERIAL PRIMARY KEY, pt GEOGRAPHY(Point, 4326));
 prepare i1 as insert into px(pt) values(ST_GeographyFromText($1));
 execute i1('SRID=4326;Point(151.215289 -33.856885)');
 prepare i2 as insert into px(pt) values($1);
 execute i2('0101000020E610000009C6C1A5E3E662406BB75D68AEED40C0');
 select id, pt, ST_Summary(pt) from px;
 }}}
 Can you turn on PostgreSQL statement logging and capture the exact SQL
 that Java is sending into the database?

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2870#comment:6>
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.