Re: allow LIMIT in UPDATE and DELETE

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.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461