Re: ERROR: "ft1" is of the wrong type.
Michael Paquier <michael@paquier.xyz>
From: Michael Paquier <michael@paquier.xyz>
To: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: peter.eisentraut@enterprisedb.com, ahsan.hadi@gmail.com, pgsql-hackers@lists.postgresql.org
Date: 2021-07-14T10:55:18Z
Lists: pgsql-hackers
On Fri, Jul 09, 2021 at 09:00:31PM +0900, Kyotaro Horiguchi wrote: > Mmm. Ok, I distributed the mother regression test into each version. Thanks, my apologies for the late reply. It took me some time to analyze the whole. > PG11, 12: > > - ATT_TABLE | ATT_PARTITIONED_INDEX > > This test doesn't detect the "is of the wrong type" issue. > > The item is practically a dead one since the combination is caught > by transformPartitionCmd before visiting ATPrepCmd, which emits a > bit different error message for the test. Yes, I was surprised to see this test choke in the utility parsing. There is a good argument in keeping (ATT_TABLE | ATT_PARTITIONED_INDEX) though. I analyzed the code and I agree that it cannot be directly reached, but a future code change on those branches may expose that. And it does not really cost in keeping it either. > PG13: > Of course this works fine but doesn't seem clean, but it is > apparently a matter of the master branch. > > - ATT_TABLE | ATT_MATVIEW | ATT_INDEX | ATT_PARTITIONED_INDEX | ATT_FOREIGN_TABLE > Added and works as expected. HEAD had its own improvements, and what you have here closes some holes of their own, so applied. Thanks! -- Michael
Commits
-
Fix unexpected error messages for various flavors of ALTER TABLE
- 85a8c3a4b60f 11.13 landed
- b242e1d239df 12.8 landed
- 5226243459f1 13.4 landed
- 0c83eb2e0edb 14.0 landed
-
Revert per-index collation version tracking feature.
- ec4831470826 14.0 cited
-
Restructure ALTER TABLE execution to fix assorted bugs.
- 1281a5c907b4 13.0 cited