Thanks, Michael and Peter, for responding; however there is a second
part to the question, which is "should I change the recursivity of
REPLICA IDENTITY, while not simultaneously changing the recusivity of
the TABLESPACE and OWNER TO forms of ALTER TABLE?"
I think everyone agrees that REPLICA IDENTITY should be changed.
+1
This is a metadata-only operation, so no problem.
The
question is whether it's bad behavior from my part to change it
separately from changing every other non-currently-recursive form.
Changing OWNER is also just a metadata-only operation and makes sense to me to recurse, by default.
SET TABLESPACE should not recurse because it copies the data, while holding long locks. If that was ever fixed so it happened concurrently, I would agree this could recurse by default.
IMHO this should be renamed to ALTER TABLE ... MOVE TO TABLESPACE, so its actual effect is clearer.
--
