Re: arrays over initdb-created types are broken after pg_upgrade - Mailing list pgsql-hackers

From Chengpeng Yan
Subject Re: arrays over initdb-created types are broken after pg_upgrade
Date
Msg-id BB860562-8922-490D-91D9-BAB43CAAE668@outlook.com
Whole thread
In response to arrays over initdb-created types are broken after pg_upgrade  (John Naylor <johncnaylorls@gmail.com>)
Responses Re: Heads Up: cirrus-ci is shutting down June 1st
List pgsql-hackers
Hi,

> On Aug 11, 2026, at 13:35, John Naylor <johncnaylorls@gmail.com> wrote:
>
> That case doesn't make any sense to me -- can you construct a concrete
> example and show what happens? In any case, it's more important here
> to avoid false positives here than false negatives, especially given
> the lack of field reports.

I initially thought that a custom variable-length type could use
`array_in`/`array_out` while setting `ELEMENT` to
`information_schema.sql_identifier`, without being its associated array.
I had overlooked that user-defined types are not allowed to use
`array_subscript_handler` directly.

I agree that "AND e.typarray = t.oid" is a reasonable criterion here.
LGTM.

--
Best regards,
Chengpeng Yan



pgsql-hackers by date:

Previous
From: Álvaro Herrera
Date:
Subject: Re: Crash issue in PG18.5 regression
Next
From: solai v
Date:
Subject: Re: postgres_fdw: Emit message when batch_size is reduced