[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:         
Component:  postgis     |     Version:  2.1.x  
 Keywords:              |  
------------------------+---------------------------------------------------

Comment(by andrewdone):

 Replying to [comment:2 pramsey]:
 > You're seeing an error in the metadata, everything about the object
 should still be OK, so your library is going to be OK. I will fix the bug
 though.

 Hi Paul,

 It actually doesn't work correctly; if you can run that Java file you'll
 see that ID:2 (not geography) doesn't work as expected with the majority
 of spatial filters (st_dwithin, st_covers, st_coversby, etc). The
 st_summary case I presented was all I could come up with to try and
 ascertain that something was different about them.

 I tried to dig into the postgis code to see what was actually different
 about them, but wasn't able to make good headway there. Sorry.

 I'm pushing the library I'm building to just use WKT and rely on the
 canonical translation to geography for now -- which works fine -- but, to
 confirm, if I used binary transfer in the manner isolated above, the only
 thing that seemed to work was st_distance. In most cases, it wasn't a case
 of getting erroneous results back, it simply wouldn't get any results back
 at all.

 So, yeah, my immediate problem is sorted but I'm more than happy to help
 in any way I can if you want to get to the bottom of it (and it'd be great
 to be able to use WKB).

 Cheers,
 - AD.

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