Re: deadlock with vacuum full on 7.4.5

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jks(at)selectacast(dot)net
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: deadlock with vacuum full on 7.4.5
Date: 2004-11-02 03:44:42
Message-ID: 29681.1099367082@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

jks(at)selectacast(dot)net writes:
> So why isn't the AccessShareLock dropped as soon as the SELECT is over?

In general, locks are held till transaction commit. See any basic
database text for the reasons why this is a good idea.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Randall Smith 2004-11-02 03:53:14 Re: oracle synchronization strategy
Previous Message jks 2004-11-02 03:24:48 Re: deadlock with vacuum full on 7.4.5