Re: Several issues with postgres_fdw stats import

From: Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>
To: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
Cc: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Several issues with postgres_fdw stats import
Date: 2026-09-18 09:23:04
Message-ID: CAPmGK14J_WQUZwKgtAQmyjk-pkYcCP88yzAUcA+D1g3m6gq6ZQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Sep 17, 2026 at 2:58 AM Corey Huinker <corey(dot)huinker(at)gmail(dot)com> wrote:
> On Wed, Sep 16, 2026 at 6:25 AM Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> wrote:

>> As the error message says, the cause of this is that the name type
>> isn't collatable in v11. It was made so in v12, so I fixed this by
>> just s/attname COLLATE "C"/attname::text COLLATE "C"/ to the query
>> generated for v11 or older.
>
> +1

>> Also, I fixed another bug in the same function: a typo in the if-test
>> to check whether the remote server is v9.2 or later.

> +1.

Pushed/backpatched.

> This is a good argument for #define-ing the relevant server version numbers going forward.

Seams like a good idea.

Thanks for looking!

Best regards,
Etsuro Fujita

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Gustafsson 2026-09-18 09:30:47 Re: pg_regress: schedule multi-line test groups
Previous Message Amit Langote 2026-09-18 09:21:55 Re: PG19: two RI fast-path issues found while testing the batching revert