[postgis-tickets] [PostGIS] #5005: ST_FlatGeoBuf crashes on tables when geometry column is not the first column (was: ST_FlatGeoBuf crashes on tables with non-geometry attributes)

PostGIS trac at osgeo.org
Sat Oct 23 09:15:16 PDT 2021


#5005: ST_FlatGeoBuf crashes on tables when geometry column is not the first
column
-----------------------+---------------------------
  Reporter:  robe      |      Owner:  pramsey
      Type:  defect    |     Status:  new
  Priority:  critical  |  Milestone:  PostGIS 3.2.0
 Component:  postgis   |    Version:  master
Resolution:            |   Keywords:
-----------------------+---------------------------

Comment (by robe):

 Okay I think I at least understand the issue now.  If the first column
 isn't the geometry and it is a numeric, it crashes.  If the first column
 is a geometry then it's fine.


 So this crashes:


 {{{
 SELECT ST_ASFlatGeobuf(t)
 FROM (SELECT 1 AS x, ST_Point(1,2) AS geom FROM test) AS t;
 }}}

 But this doesn't:


 {{{
 SELECT ST_ASFlatGeobuf(t)
 FROM (SELECT ST_Point(1,2) AS geom, 1 AS x FROM test) AS t;

 }}}

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