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

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