[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 robe):

 This is interesting

 I noticed if I add this


 {{{
 insert into px(pt) values
 ('0101000020E610000009C6C1A5E3E662406BB75D68AEED40C0'::geometry);

 select id, pt, ST_Summary(pt) from px;
 }}}


 I get:


 {{{
  id |                         pt                         | st_summary
 ----+----------------------------------------------------+------------
   1 | 0101000020E610000009C6C1A5E3E662406BB75D68AEED40C0 | Point[GS]
   2 | 0101000020E610000009C6C1A5E3E662406BB75D68AEED40C0 | Point[GS]
   3 | 0101000020E610000009C6C1A5E3E662406BB75D68AEED40C0 | Point[BGS]
 }}}


 How come the one I create with geometry cast has a cached bounding box and
 the others don't?

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