On 2023-02-01 We 20:03, Tom Lane wrote: > > Anyway, after re-reading the old thread I wonder if my first instinct > (force --load-via-partition-root for enum hash cases only) was the > best compromise after all. I'm not sure how painful it is to get > pg_dump to detect such cases, but it's probably possible. > >
Given the other problems you enumerated upthread, I'd be more inclined to go with your other suggestion of "--load-via-partition-root=on/off/auto" (with the default presumably "auto"). cheers andrew -- Andrew Dunstan EDB: https://www.enterprisedb.com