Re: getting deadlocks on full table lock

"Merlin Moncure" <mmoncure@gmail.com> writes:
> I am getting a deadlock which I can't explain...although maybe
> somebody else can...here's teh situation:

TRUNCATE requires exclusive lock, and won't release it until end of
transaction.  Since you've already read something from the target
table before attempting TRUNCATE, you already have AccessShareLock
and are attempting to acquire AccessExclusiveLock.  Classic deadly
embrace.

            regards, tom lane