On Tue, Aug 9, 2016 at 5:17 PM, Jim Nasby <jim.na...@bluetreble.com> wrote:
> On 8/5/16 12:00 PM, Jeff Janes wrote: > >> So I created a new guc, notice_lock_waits, which acts like >> log_lock_waits but sends the message as NOTICE so it will show up on >> interactive connections like psql. >> > > I would strongly prefer that this accept a log level instead of being > hard-coded to NOTICE. The reason is that I find the NOTICE chatter from > many DDL commands to be completely worthless (looking at you %TYPE), Perhaps we should do something about those notices? In 9.3 we removed ones about adding implicit unique indexes to implement primary keys, and I think that that was a pretty good call. > so I normally set client_min_messages to WARNING in DDL scripts. I can > work on that patch; would it essentially be a matter of changing > notice_lock_waits to int lock_wait_level? How would it be turned off? Is there a err level which would work for that? And what levels would non-superusers be allowed to set it to? And, I'd be happy if you were to work on a patch to implement it. Cheers, Jeff
