Re: Deadlock - Mailing list pgsql-docs

From Peter Eisentraut
Subject Re: Deadlock
Date
Msg-id Pine.LNX.4.30.0105251804460.758-100000@peter.localdomain
Whole thread Raw
In response to Deadlock  (Joseph Paris <paris@mcs.anl.gov>)
List pgsql-docs
Joseph Paris writes:

> I was wondering how pgsql handles multile requests to lock a table?  Say
> there are 5 concurent threads attempting a lock on a DB... does pgsql
> assign an arbritrary order to these requests or does it just ignore?

Presuming that the locks actually conflict, the other 4 will block waiting
for the first transaction to release the lock.  See LOCK reference page.

Btw., this is not the mailing list for usage questions.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-docs by date:

Previous
From: Joseph Paris
Date:
Subject: Deadlock
Next
From: Peter Eisentraut
Date:
Subject: Re: Additions to the Oracle porting doc