Re: allow LIMIT in UPDATE and DELETE - Mailing list pgsql-general

From Bruce Momjian
Subject Re: allow LIMIT in UPDATE and DELETE
Date
Msg-id 200605232215.k4NMF3J24585@candle.pha.pa.us
Whole thread Raw
In response to Re: allow LIMIT in UPDATE and DELETE  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: allow LIMIT in UPDATE and DELETE  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-general
Jim C. Nasby wrote:
> On Tue, May 23, 2006 at 10:19:25AM +0200, Csaba Nagy wrote:
> > On Mon, 2006-05-22 at 23:55, Jim C. Nasby wrote:
> > > BTW, there's a bug/issue with CLUSTER that makes it not entirely
> > > transaction safe.
> >
> > For God's sake, don't fix that one ! I rely on it... now seriously,
> > until there's a way to tell the DB that an exclusive lock is enough to
> > vacuum all dead rows, even if they would be visible by other
> > transactions, CLUSTER is the only thing I can use to circumvent the long
> > running transaction syndrome.
>
> I believe it's already fixed in HEAD/8.2.

If it is, TODO doesn't reflect that:

    * Make CLUSTER preserve recently-dead tuples per MVCC
      requirements

--
  Bruce Momjian   http://candle.pha.pa.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: allow LIMIT in UPDATE and DELETE
Next
From: "Florian G. Pflug"
Date:
Subject: Re: "make check" fails over NFS or tmpfs