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

PostGIS trac at osgeo.org
Fri Aug 1 23:34:45 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:         
Component:  postgis     |     Version:  2.1.x  
 Keywords:              |  
------------------------+---------------------------------------------------

Comment(by andrewdone):

 Postgres log entry for the binary insert is:

 {{{
 LOG: execute : insert into px(pt) values($1)
 DETAIL: parameters: $1 =
 '\x0101000020e610000009c6c1a5e3e662406bb75d68aeed40c0'
 }}}

 Output as SQL:
 {{{
  id |                         pt                         | st_summary
 ----+----------------------------------------------------+------------
   1 | 0101000020E610000009C6C1A5E3E662406BB75D68AEED40C0 | Point[GS]
   2 | 0101000020E610000009C6C1A5E3E662406BB75D68AEED40C0 | Point[S]
 }}}

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