Re: pgsql: Fill tuple before HeapSatisfiesHOTAndKeyUpdate - Mailing list pgsql-committers

From Bruce Momjian
Subject Re: pgsql: Fill tuple before HeapSatisfiesHOTAndKeyUpdate
Date
Msg-id 20130201172504.GB2371@momjian.us
Whole thread Raw
In response to pgsql: Fill tuple before HeapSatisfiesHOTAndKeyUpdate  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: pgsql: Fill tuple before HeapSatisfiesHOTAndKeyUpdate
List pgsql-committers
On Fri, Feb  1, 2013 at 01:50:02PM +0000, Álvaro Herrera wrote:
> Fill tuple before HeapSatisfiesHOTAndKeyUpdate
>
> Failing to do this results in almost all updates to system catalogs
> being non-HOT updates, because the OID column would differ (not having
> been set for the new tuple), which is an indexed column.
>
> While at it, make sure to set the tableoid early in both old and new
> tuples as well.  This isn't of much consequence, since that column is
> seldom (never?) indexed.
>
> Report and patch from Andres Freund.

Was this a new bug in 9.3?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +


pgsql-committers by date:

Previous
From: Alvaro Herrera
Date:
Subject: pgsql: Fix typo in freeze_table_age implementation
Next
From: Andres Freund
Date:
Subject: Re: pgsql: Fill tuple before HeapSatisfiesHOTAndKeyUpdate