[postgis-tickets] [PostGIS] #4916: st_asgeobuf() with WINDOW PARTITION crashes server

PostGIS trac at osgeo.org
Tue May 18 05:28:55 PDT 2021


#4916: st_asgeobuf() with WINDOW PARTITION crashes server
-------------------------+---------------------------
 Reporter:  Robins       |      Owner:  pramsey
     Type:  defect       |     Status:  new
 Priority:  medium       |  Milestone:  PostGIS 3.1.2
Component:  postgis      |    Version:  3.0.x
 Keywords:  st_asgeobuf  |
-------------------------+---------------------------
 When I use `st_asgeobuf()` with WINDOW PARTITION it crashes server. Here
 is a simple example.

 {{{
 $ psql
 psql (13beta2, server 13.3)
 Type "help" for help.

 regression=> \x
 Expanded display is on.

 regression=> \dx postgis
 List of installed extensions
 -[ RECORD 1
 ]--------------------------------------------------------------------
 Name        | postgis
 Version     | 3.0.3
 Schema      | public
 Description | PostGIS geometry, geography, and raster spatial types and
 functions

 regression=> \x
 Expanded display is off.
 regression=> SELECT public.st_asgeobuf(NULL::pg_class, version()) over
 (partition by RANDOM());
 server closed the connection unexpectedly
         This probably means the server terminated abnormally
         before or while processing the request.
 The connection to the server was lost. Attempting reset: Failed.
 !?> \q

 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4916>
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