[PostGIS] #3110: Use 64bit integers for identifiers

PostGIS trac at osgeo.org
Mon Jul 14 19:57:32 PDT 2025


#3110: Use 64bit integers for identifiers
--------------------------+---------------------------
  Reporter:  strk         |      Owner:  strk
      Type:  enhancement  |     Status:  closed
  Priority:  medium       |  Milestone:  PostGIS 3.6.0
 Component:  topology     |    Version:  master
Resolution:  fixed        |   Keywords:
--------------------------+---------------------------
Changes (by Regina Obe <lr@…>):

 * resolution:   => fixed
 * status:  new => closed

Comment:

 In [changeset:"43110503fda73aa1938e4eddccd92785f82d094e/git"
 43110503/git]:
 {{{#!CommitTicketReference repository="git"
 revision="43110503fda73aa1938e4eddccd92785f82d094e"
 Topology support for big int
 Closes #3110 for PostGIS 3.6.0
 References https://git.osgeo.org/gitea/postgis/postgis/pulls/242
 Closes https://git.osgeo.org/gitea/postgis/postgis/pulls/242
 References https://github.com/postgis/postgis/pull/822

 * Update c types to support int64 instead of int32 for IDs -
 face,edge,node,element,topogeo
 * Modify the pre and post scripts including the restore, uninstall and
 upgrade script generators
 * Upgrade core elements to support bigint - topoelement, topoelementarray
 and topogeometry
 * Modify createtopogeom to support bigint including tests
 * Modify createtopology - consolidate into single function and add large
 ids support
 * Modified addtopogeomcolumn - added support for bigint including tests
 * Modify topology query methods that need bigint
 * Modify topology sql functions that require bigint for input or output
 (including tests)
 * Modify validatetopology to support large ids. Also modified copytopology
 and topologysummary including tests
 * Add dedicated tests for large id topologies
 * Add topology.upgradetopology function
 * Update NEWS
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3110#comment:9>
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