Re: Further cleanup related to statistics import support in postgres_fdw

From: Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
Subject: Re: Further cleanup related to statistics import support in postgres_fdw
Date: 2026-09-07 10:21:04
Message-ID: CAPmGK17XWjgOd0MZia0mu1Z+-kO+osaLhf+pBefiL4KWRbLUqw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Sep 6, 2026 at 7:45 PM Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> wrote:
> On Sat, Sep 5, 2026 at 1:23 AM Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> wrote:
> > 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."
>
> I expanded this to something like the attached.

Upon reconsideration, I think it's better to adjust the WARNING
message like this, rather than just adding the lengthy note.

ereport(WARNING,
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
- errmsg("could not import statistics
for foreign table \"%s.%s\" --- remote table \"%s.%s\" is inherited",
+ errmsg("could not import statistics
for foreign table \"%s.%s\" --- remote table \"%s.%s\" is (or was
once) inherited",
local_schemaname, local_relname,
remote_schemaname, remote_relname));

Attached is an updated patch for that, in which I simplified a near-by
code comment as well as that note. Comments welcome!

Best regards,
Etsuro Fujita

Attachment Content-Type Size
add-note-about-stats-import-restrictions-v2.patch application/octet-stream 2.0 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2026-09-07 10:26:24 Re: Crashes on a partition whose concurrent detach never finished
Previous Message Henson Choi 2026-09-07 10:13:41 Re: Row pattern recognition