[PostGIS] #5957: ST_GetFaceEdges return bigint in some cases

PostGIS trac at osgeo.org
Mon Jul 28 00:53:18 PDT 2025


#5957: ST_GetFaceEdges return bigint in some cases
--------------------------------+---------------------------
  Reporter:  Lars Aksel Opsahl  |      Owner:  strk
      Type:  defect             |     Status:  new
  Priority:  medium             |  Milestone:  PostGIS 3.6.0
 Component:  topology           |    Version:  master
Resolution:                     |   Keywords:
--------------------------------+---------------------------
Comment (by Lars Aksel Opsahl):

 Here is a sample of the problem.

 SELECT abs(t.edge) AS edge_id
                         FROM
 topology.ST_GetFaceEdges('arstat_04_topo_72',582) As t(seq,edge);
  edge_id
 ---------
      422
      647
      440
      619
      458
      568
      592
 (7 rows)

 cpu11.int.nibio.no postgres at rog_02=# create table test_5957 as (SELECT
 abs(t.edge) AS edge_id
                         FROM
 topology.ST_GetFaceEdges('arstat_04_topo_72',582) As t(seq,edge));
 SELECT 7
 cpu11.int.nibio.no postgres at rog_02=# \d test_5957
              Table "public.test_5957"
  Column  |  Type  | Collation | Nullable | Default
 ---------+--------+-----------+----------+---------
  edge_id | bigint |           |          |
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5957#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