On Fri, May 27, 2022 at 05:25:43PM +0900, Yugo NAGATA wrote: > --- TRUNCATE doesn't work on foreign tables, either directly or recursively > -TRUNCATE ft2; -- ERROR > -ERROR: foreign-data wrapper "dummy" has no handler > -TRUNCATE fd_pt1; -- ERROR > -ERROR: foreign-data wrapper "dummy" has no handler > DROP TABLE fd_pt1 CASCADE;
In the case of this test, fd_pt1 is a normal table that ft2 inherits, so this TRUNCATE command somewhat checks that the TRUNCATE falls back to the foreign table in this case. However, this happens to be tested in postgres_fdw (see around tru_ftable_parent), > --- TRUNCATE doesn't work on foreign tables, either directly or recursively > -TRUNCATE fd_pt2_1; -- ERROR > -ERROR: foreign-data wrapper "dummy" has no handler > -TRUNCATE fd_pt2; -- ERROR > -ERROR: foreign-data wrapper "dummy" has no handler Partitions have also some coverage as far as I can see, so I agree that it makes little sense to keep the tests you are removing here. -- Michael
signature.asc
Description: PGP signature
