Opened 7 months ago

Closed 6 months ago

#4714 closed defect (fixed)

populate_geometry_columns function ignores partitioned tables

Reported by: robe Owned by: pramsey
Priority: medium Milestone: PostGIS 3.1.0
Component: postgis Version: 2.5.x
Keywords: Cc:


Looks like we are missing filter for 'p' child partitions in the populate_geometry piece. This should be rightfully ignored for type mod since partitioned have to have the same structure as the parent partition, but they can have check constraints applied to them different from parent. So can be done with use_typmod = false is chosen.

Change History (3)

comment:1 Changed 7 months ago by robe

Summary: populate_geometry function ignores partitioned tablespopulate_geometry_columns function ignores partitioned tables

comment:2 Changed 7 months ago by Regina Obe <lr@…>

In 6700df0e/git:

add partitions to populate_geometry_columns consideration references #4714 for PostGIS 3.1.0

comment:3 Changed 6 months ago by robe

Milestone: PostGIS 2.5.5PostGIS 3.1.0
Resolution: fixed
Status: newclosed

Decided not worth backporting

Note: See TracTickets for help on using tickets.