"Merlin Moncure" <mmoncure@xxxxxxxxx> 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
