On 2026-10-29 Th 1:05 AM, jian he wrote:
To summarize where this thread: v5-0001 is a fix for PG19. v5-0002 and v5-0003 fix the problem for PG18 as well. However, they require us to accept that pg_dump may restore a child's inherited CHECK constraint with pg_constraint.conislocal = true, even though it was false in the original database. The visible consequence is that, after a restore, ALTER TABLE ... DROP CONSTRAINT on the parent no longer drops the child's copy of the constraint; the child keeps it as a local constraint. (Given table inheritance is not liked by many people, maybe it's OK to change conislocal for table inheritance, but not partitioning inheritance)
Yeah, I'm going to commit patch 0001, which is pretty straightforward, to close the pg19 open item, and leave the remaining items for later discussion.
cheers andrew -- Andrew Dunstan EDB: https://www.enterprisedb.com
