Re: XversionUpgrade tests broken by postfix operator removal
Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
From: Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@lists.postgresql.org, pgbf@twiska.com
Date: 2020-09-19T11:46:49Z
Lists: pgsql-hackers
On 9/18/20 6:05 PM, Tom Lane wrote:
> I wrote:
>> Andrew Dunstan <andrew.dunstan@2ndquadrant.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 #@# (bigint, NONE);
CREATE OPERATOR #@# (
PROCEDURE = factorial,
LEFTARG = bigint
);
drop operator @#@ (NONE, bigint);
CREATE OPERATOR @#@ (
PROCEDURE = factorial,
RIGHTARG = bigint
);
-- rel 9.4
drop operator #@%# (bigint, NONE);
CREATE OPERATOR public.#@%# (
PROCEDURE = factorial,
LEFTARG = bigint
);
cheers
andrew
--
Andrew Dunstan https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Commits
-
In pg_upgrade cross-version test, handle postfix operators.
- fa744697c791 14.0 landed
-
Use factorial rather than numeric_fac in create_operator.sql.
- cc7b27da7fb8 11.10 landed
- a950fb073426 10.15 landed
- 9ab5ed4194f3 13.0 landed
- 760b8fe766bc 9.5.24 landed
- 1e00333ffa2e 9.6.20 landed
- 1af91dc032cf 12.5 landed
-
Remove support for postfix (right-unary) operators.
- 1ed6b895634c 14.0 cited