Re: BUG #10189: Limit in 9.3.4 no longer works when ordering using a composite multi-type index - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #10189: Limit in 9.3.4 no longer works when ordering using a composite multi-type index
Date
Msg-id 20140505195633.GN6018@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: BUG #10189: Limit in 9.3.4 no longer works when ordering using a composite multi-type index  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #10189: Limit in 9.3.4 no longer works when ordering using a composite multi-type index  (wayneh <wayneh@mirthcorp.com>)
Re: BUG #10189: Limit in 9.3.4 no longer works when ordering using a composite multi-type index  (Devrim GÜNDÜZ <devrim@gunduz.org>)
List pgsql-bugs
Tom Lane wrote:
> Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> > Nick Rupley wrote:
> >> Not sure if this is relevant or not, but it looks like the duplicate rows
> >> continue to be inserted here and there on our production box (to which we
> >> haven't yet applied the hotfix). As I stated before that production box did
> >> have some server crashes before, but actually it hasn't had any recently
> >> (in the past week), and yet the duplicate rows continue to happen.
>
> > This bug is not dependent on a crash; the corruption occurs to the live
> > data.  Only the previous bug mentioned by Tom manifested itself during
> > crash recovery.
>
> Hm.  If people are hitting this in the field, do we need to think about
> yet another fairly-high-priority update release?

It appears so :-(

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #10189: Limit in 9.3.4 no longer works when ordering using a composite multi-type index
Next
From: Nick Rupley
Date:
Subject: Re: BUG #10189: Limit in 9.3.4 no longer works when ordering using a composite multi-type index