On Thu, Apr 6, 2023 at 1:58 AM Pavel Stehule <pavel.steh...@gmail.com> wrote: > > st 5. 4. 2023 v 19:20 odesílatel Greg Stark <st...@mit.edu> napsal: >> >> On Sun, 26 Mar 2023 at 07:34, Julien Rouhaud <rjuju...@gmail.com> wrote: >> > >> > This feature can significantly increase log size, so it's disabled by >> > default. >> > For testing or development environments it's recommended to enable it if >> > you >> > use session variables. >> >> I think it's generally not practical to have warnings for valid DML. >> Effectively warnings in DML are errors since they make the syntax just >> unusable. I suppose it's feasible to have it as a debugging option >> that defaults to off but I'm not sure it's really useful. > > > It is a tool that should help with collision detection. Without it, it can > be pretty hard to detect it. It is similar to plpgsql's extra warnings.
Another example is escape_string_warning, which can also emit warning for valid DML. I once had to fix some random framework that a previous employer was using, in order to move to a more recent pg version and have standard_conforming_strings on, and having escape_string_warning was quite helpful.