Request a Demo
Home   >   mailing lists

Re: Commit with wait event on advisory lock! - Mailing list pgsql-admin

From Tom Lane
Subject Re: Commit with wait event on advisory lock!
Date
Msg-id 3505513.1737506928@sss.pgh.pa.us
Whole thread Raw
In response to RE: Commit with wait event on advisory lock!  (<msalais@msym.fr>)
Responses RE: Commit with wait event on advisory lock!
List pgsql-admin
Tree view 
<msalais@msym.fr> writes:
> How a COMMIT statement could be blocked by a lock whatever the kind of the lock could be. COMMIT releases locks. How
couldit 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

pgsql-admin by date:

Previous
From:
Date:
Subject: RE: Commit with wait event on advisory lock!
Next
From: Tom Lane
Date:
Subject: Re: Is there a way to check if objects are created with quotes or not?