Re: insert waiting - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: insert waiting
Date
Msg-id 20040820131822.GD20737@wolff.to
Whole thread Raw
In response to Re: insert waiting  (Ulrich Wisser <ulrich.wisser@relevanttraffic.se>)
List pgsql-general
On Fri, Aug 20, 2004 at 13:20:49 +0200,
  Ulrich Wisser <ulrich.wisser@relevanttraffic.se> wrote:
> Hi John,
>
> but how long is the exclusive lock taken? For the whole transaction?
> My jobs are quite big, and transactions usually take several minutes.
> I can not afford have all my other jobs stalled for that time.

Once a lock is taken by a transaction, it is held until the end of that
transaction.

pgsql-general by date:

Previous
From: Ulrich Wisser
Date:
Subject: Adding missing FROM-clause entry for table "customer"
Next
From: Bruno Wolff III
Date:
Subject: Re: 7.4.5 release