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

PostGIS trac at osgeo.org
Wed Mar 19 06:42:49 PDT 2025


#3110: Use 64bit integers for identifiers
--------------------------+-----------------------------
  Reporter:  strk         |      Owner:  strk
      Type:  enhancement  |     Status:  new
  Priority:  medium       |  Milestone:  PostGIS Fund Me
 Component:  topology     |    Version:  master
Resolution:               |   Keywords:
--------------------------+-----------------------------
Comment (by adesugbaa):

 We are researching migrating TIGER to POSTGIS, and would need IDs larger
 than the current integer. We do not need this for primitive IDs, but for
 consistency we can decide to use BIGINT (INT8) for all IDs, related
 tables, functions and types.

 I have made local changes to our instance, but we will need this in the
 base product so we can use cloud services like AWS Aurora for our proof of
 concept.

 I will be contributing these changes to the extension.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3110#comment:7>
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