On Tue, Sep 15, 2026 at 5:52 PM Fujii Masao <[email protected]> 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


Reply via email to