[postgis-devel] [PostGIS] #1106: OpenJump (JTS): Unknown WKB type 48

PostGIS trac at osgeo.org
Wed Jul 6 11:27:50 PDT 2011

#1106: OpenJump (JTS): Unknown WKB type 48
 Reporter:  aperi2007  |       Owner:  pramsey      
     Type:  defect     |      Status:  new          
 Priority:  critical   |   Milestone:  PostGIS 2.0.0
Component:  postgis    |     Version:  trunk        
 Keywords:             |  

Comment(by aperi2007):

 Hi Robe,

 select st_asbinary(geom) from <table>

 work well.
 I use a tool of OJ that need to write the query sql.
 So is quite simple to add the ST_AsBinary()

 So I think this ticket could be closed as invalid

 I agree with your opinion


 Replying to [comment:11 robe]:
 > Andrea -- how are you querying OpenJump?  I don't get the error you have
 above about wkb type, but I'm running a slightly newer PostGIS.  With ad-
 hoc tool it gives that error if you don't do an ST_AsBinary on the column
 > but that has always been the case.
 > SO:
 > {{{
 > -- this works
 > SELECT ST_AsBinary(geom)
 > FROM tl_2010_25_zcta510
 > }}}
 > {{{
 > -- this will give a type 48 error in ad-hoc tool
 > SELECT geom
 > FROM tl_2010_25_zcta510;
 > }}}
 > FWIW -- if I install the missing legacy functions, my OpenJump works
 fine with the add data store layer option also.  So I don't think there is
 an issue with OpenJump, just QGIS.

Ticket URL: <http://trac.osgeo.org/postgis/ticket/1106#comment:13>
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-devel mailing list