Re: XversionUpgrade tests broken by postfix operator removal

On 9/18/20 6:05 PM, Tom Lane wrote:
> I wrote:
>> Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com> writes:
>>> Yeah, probably worth doing. It's a small enough change and it's only in
>>> the test suite.
>> OK, I'll go take care of that in a bit.
> Done, you should be able to remove @#@ (NONE, bigint) from the
> kill list.
>
>

Done.

crake tests pg_upgrade back to 9.2, so I had to mangle those static
repos for non-live branches like this:

-- rel 9.2 on

drop operator #%# (bigint, NONE);
CREATE OPERATOR #%# (
    PROCEDURE = factorial,
    LEFTARG = bigint
);

drop operator #(at)# (bigint, NONE);
CREATE OPERATOR #(at)# (
    PROCEDURE = factorial,
    LEFTARG = bigint
);

drop operator @#@ (NONE, bigint);
CREATE OPERATOR @#@ (
    PROCEDURE = factorial,
    RIGHTARG = bigint
);

-- rel 9.4
drop operator #(at)%# (bigint, NONE);
CREATE OPERATOR public(dot)#(at)%# (
    PROCEDURE = factorial,
    LEFTARG = bigint
);

cheers

andrew

--
Andrew Dunstan https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services