Postgres error “Delete is pending, will be blocked” is incorrect but can’t be cleared
I’m not sure how I got into this situation, but recently our application cannot delete any row from one particular table. I checked and we cannot even delete it from psql shell. This is the error:
Locks on catalog tables
I have created a procedure that returns an event trigger:
Whenever an ALTER TABLE
occurs SELECT
is granted on all sequences on all tables to a specific user.