Re: Several issues with postgres_fdw stats import

On Tue, Sep 15, 2026 at 5:52 PM Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
> When I used v11 as the remote server, stats import via postgres_fdw
> resulted in the following error. I think this should be addressed as well.
>
> ERROR: collations are not supported by type name
> CONTEXT: remote SQL command: SELECT DISTINCT ON (attname COLLATE "C")
> attname, null_frac, avg_width, n_distinct, most_common_vals,
> most_common_freqs, histogram_bounds, correlation, most_common_elems,
> most_common_elem_freqs, elem_count_histogram, NULL, NULL, NULL FROM
> pg_catalog.pg_stats WHERE schemaname = 'public' AND tablename = 't'
> AND attname = ANY(ARRAY['i', 'j']) ORDER BY attname COLLATE "C",
> inherited DESC

Reproduced here. Will fix.

I was thinking this lacks testing against old servers, so thanks for
the testing and report!

Best regards,
Etsuro Fujita