On 2024-Apr-15, Alvaro Herrera wrote:
> - Fourth thought: we do as in the third thought, except we also allow
> DROP CONSTRAINT a constraint that's marked "local, inherited" to be
> simply an inherited constraint (remove its "local" marker).
Here is an initial implementation of what I was thinking. Can you
please give it a try and see if it fixes this problem? At least in my
run of your original test case, it seems to work as expected.
This is still missing some cleanup and additional tests, of course.
Speaking of which, I wonder if I should modify pg16's tests so that they
leave behind tables set up in this way, to immortalize pg_upgrade
testing.
--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/