Skip site navigation (1) Skip section navigation (2)

Re: Deadlock

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Joseph Paris <paris(at)mcs(dot)anl(dot)gov>
Cc: <pgsql-docs(at)postgresql(dot)org>
Subject: Re: Deadlock
Date: 2001-05-25 16:06:30
Message-ID: Pine.LNX.4.30.0105251804460.758-100000@peter.localdomain (view raw or flat)
Thread:
Lists: 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(at)gmx(dot)net   http://funkturm.homeip.net/~peter


In response to

  • Deadlock at 2001-05-25 15:11:37 from Joseph Paris

pgsql-docs by date

Next:From: Peter EisentrautDate: 2001-05-25 19:42:09
Subject: Re: Additions to the Oracle porting doc
Previous:From: Joseph ParisDate: 2001-05-25 15:11:37
Subject: Deadlock

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group