On Tue, Jul 21, 2026 at 6:45 PM Hayato Kuroda (Fujitsu) <[email protected]> wrote: > Not sure, but can we also meet the similar situation via ALTER USER MAPPING > ... (DROP password) command? I.e., the command would succeed but the worker > will fail. > If so, should we also fix the case? Or it's something like "Don't do that" > situation?
Yes, a similar situation can probably be created also by changing the underlying user mapping. But, I think that's part of a broader dependency invalidation problem. Similar issues could also arise from commands such as DROP USER MAPPING, ALTER SERVER, and ALTER FOREIGN DATA WRAPPER ... CONNECTION/NO CONNECTION. If we decide to address the ALTER USER MAPPING case, we should probably consider those related cases as well. Since that's a broader topic, I think it's better to discuss that separately. Regards, -- Fujii Masao
