array_cat anycompatible change is breaking xversion upgrade tests

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: array_cat anycompatible change is breaking xversion upgrade tests
Date: 2020-11-05 00:43:51
Message-ID: 1401824.1604537031@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

crake is showing xversion upgrade failures since 9e38c2bb50:

pg_restore: error: could not execute query: ERROR: function array_cat(anyarray, anyarray) does not exist
Command was: CREATE AGGREGATE "public"."array_cat_accum"("anyarray") (
SFUNC = "array_cat",
STYPE = "anyarray",
INITCOND = '{}'
);

As was discussed in the thread leading up to that commit, modifying the
signature of array_cat and friends could break user-defined operators
and aggregates based on those functions. It seems to me that the
usability gain from this change is worth that cost, but it is causing
an issue for xversion tests.

I think the most plausible response is to add this aggregate to the filter
logic that already exists in the xversion tests. Perhaps we could
alternatively change this test case so that it relies on some other
polymorphic function, but I'm not quite sure what a good candidate
would be.

regards, tom lane

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2020-11-05 01:21:27 Re: PANIC: could not fsync file "pg_multixact/..." since commit dee663f7843
Previous Message thehesiod 2020-11-05 00:39:55 Re: overriding current_timestamp