Opened 5 years ago

Last modified 7 months ago

#3110 new enhancement

Use 64bit integers for identifiers

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS Fund Me
Component: topology Version: master
Keywords: Cc: aperi


Topology primitive tables are created with 32bit integer identifiers. This ticket is to use 64bit integers instead.

Note that such change would also affect the relation table and the TopoElement? and TopoElementArray? domains.

An upgrade path should also be provided to alter existing topologies.

Change History (6)

comment:1 Changed 5 years ago by strk

NOTE: sequences already use 64bit integers (bigint) so it is only a matter of using ALTER TABLE for the tables (and something for the domains)

comment:2 Changed 4 years ago by strk

Milestone: PostGIS 2.2.0PostGIS 2.3.0

comment:3 Changed 3 years ago by robe

Milestone: PostGIS 2.3.0PostGIS 2.4.0

comment:4 Changed 2 years ago by robe

Milestone: PostGIS 2.4.0PostGIS 2.5.0

comment:5 Changed 19 months ago by komzpa

Milestone: PostGIS 2.5.0PostGIS 3.0.0

comment:6 Changed 7 months ago by komzpa

Milestone: PostGIS 3.0.0PostGIS Fund Me
Note: See TracTickets for help on using tickets.