On Fri, Sep 4, 2026 at 11:25 PM Etsuro Fujita <[email protected]> wrote: > This is expected behavior, because postgres_fdw determines whether the > remote table is inherited or not, by checking only the table's > relhassubclass. We could check pg_inherits as well, to detect false > positives like this, but I didn't do so, because I don't think that > that is worth complicating the code, as table inheritance is not that > popular these days in the first place. Should we? I think another > option would be to add a note about this behavior.
We are really nearing the end of the beta stabilization phase, I feel like just adding the note like this: "Note that if the remote table was inherited in the past, postgres_fdw currently considers it inherited even if it is not currently inherited. This restriction might be fixed in a future release." Best regards, Etsuro Fujita
