Re: Commit with wait event on advisory lock!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: msalais(at)msym(dot)fr
Cc: "'Rajesh Kumar'" <rajeshkumar(dot)dba09(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Commit with wait event on advisory lock!
Date: 2025-01-22 00:48:48
Message-ID: 3505513.1737506928@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

<msalais(at)msym(dot)fr> writes:
> How a COMMIT statement could be blocked by a lock whatever the kind of the lock could be. COMMIT releases locks. How could it be blocked by a lock?!

There could be pre-commit actions (for example, firing deferred
triggers) that need to take locks the transaction didn't already
hold. You've provided no details that would let anyone diagnose
the exact cause, though.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2025-01-22 00:52:29 Re: Is there a way to check if objects are created with quotes or not?
Previous Message msalais 2025-01-22 00:22:09 RE: Commit with wait event on advisory lock!