On 3/27/06, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Merlin Moncure" <[EMAIL PROTECTED]> writes:
> > I am getting a deadlock which I can't explain...although maybe
> > somebody else can...here's the situation:
>
> TRUNCATE requires exclusive lock, and won't release it until end of
> transaction. Sin
"Merlin Moncure" <[EMAIL PROTECTED]> 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 befo
I am getting a deadlock which I can't explain...although maybe
somebody else can...here's teh situation:
I have a plpgsql function which increments a sequence when called.
when the sequence hits a certain threshold, the sequence is reset and
a materilized structure (small table) is updated. The o
