Re: Add “FOR UPDATE NOWAIT” lock details to the log. - Mailing list pgsql-hackers

From Yuki Seino
Subject Re: Add “FOR UPDATE NOWAIT” lock details to the log.
Date
Msg-id a479740c-fe28-42f5-be83-272c0127cf86@oss.nttdata.com
Whole thread Raw
In response to Re: Add “FOR UPDATE NOWAIT” lock details to the log.  (Fujii Masao <masao.fujii@oss.nttdata.com>)
Responses Re: Add “FOR UPDATE NOWAIT” lock details to the log.
List pgsql-hackers
> Pushed the patch. Thanks!

Thank you. I'm very happy !!


> Using the newly introduced mechanism, we can now easily extend
> the log_lock_failure GUC to support additional NOWAIT lock failures,
> such as LOCK TABLE ... NOWAIT, ALTER TABLE ... NOWAIT,
> ALTER MATERIALIZED VIEW ... NOWAIT, and ALTER INDEX ... NOWAIT.
>
> I've attached a patch implementing this.
That's a very good suggestion.

There is just one thing that bothers me.
ConditionalLockRelationOid() seems to be used by autovacuum as well.
Wouldn't this information be noise to the user?

Regards,



pgsql-hackers by date:

Previous
From: Amul Sul
Date:
Subject: Re: NOT ENFORCED constraint feature
Next
From: vignesh C
Date:
Subject: Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row