Opened 4 years ago

Closed 4 years 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 -- EOL
Keywords: Cc:

Description

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 by robe, 4 years ago

Summary: populate_geometry function ignores partitioned tablespopulate_geometry_columns function ignores partitioned tables

comment:2 by Regina Obe <lr@…>, 4 years ago

In 6700df0e/git:

add partitions to populate_geometry_columns consideration references #4714 for PostGIS 3.1.0

comment:3 by robe, 4 years ago

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

Decided not worth backporting

Note: See TracTickets for help on using tickets.