From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | Re: pgsql: Declare assorted array functions using anycompatible not anyelem |
Date: | 2020-11-10 13:45:06 |
Message-ID: | dc77bfb2-3b98-c3e5-a825-6c087d51f51c@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
On 11/9/20 5:41 PM, Tom Lane wrote:
>
> What I have in mind to apply to 9.5 through 13 is per attached.
> You could either redefine the aggregate similarly in 9.2-9.4,
> or just drop it. I doubt the latter leads to any interesting
> loss of coverage for xversion upgrade, as there's plenty of other
> user-defined aggregates in the regression database.
You also need to modify first_el_agg_any.
Here's what I have working on crake::
if ($oversion le 'REL9_4_STABLE')
{
# this is to be fixed in 9.5 and later
$prstmt = join(';',
'drop aggregate if exists
public.array_cat_accum(anyarray)',
'CREATE AGGREGATE array_larger_accum
(anyarray) ' .
' ( ' .
' sfunc = array_larger, ' .
' stype = anyarray, ' .
' initcond = $${}$$ ' .
' ) ' );
system( "$other_branch/inst/bin/psql -X -e "
. " -c '" . $prstmt . "' "
. "regression "
. ">> '$upgrade_loc/$oversion-copy.log' 2>&1");
return if $?;
}
# drop this branch when upstream is renovated
else
{
$prstmt = join(';',
'drop aggregate if exists
public.array_cat_accum(anyarray)',
'drop aggregate if exists
public.first_el_agg_any(anyelement)');
system( "$other_branch/inst/bin/psql -X -e "
. " -c '$prstmt' "
. "regression "
. ">> '$upgrade_loc/$oversion-copy.log' 2>&1");
return if $?;
}
When you fix the live branches I'll delete the "else" branch and push
the change to the git repo.
cheers
andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2020-11-10 17:26:20 | pgsql: pg_rewind: Fix thinko in parsing target WAL. |
Previous Message | Magnus Hagander | 2020-11-10 12:16:50 | pgsql: Remove -o option to postmaster |