Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql: Make SELECT FOR UPDATE/SHARE work on inheritance trees, by having - Mailing list pgsql-committers

From Bruce Momjian
Subject Re: pgsql: Make SELECT FOR UPDATE/SHARE work on inheritance trees, by having
Date
Msg-id 200811201635.mAKGZwM06609@momjian.us
Whole thread Raw
In response to pgsql: Make SELECT FOR UPDATE/SHARE work on inheritance trees, by having  (tgl@postgresql.org (Tom Lane))
List pgsql-committers
Tree view 
Tom Lane wrote:
> Log Message:
> -----------
> Make SELECT FOR UPDATE/SHARE work on inheritance trees, by having the plan
> return the tableoid as well as the ctid for any FOR UPDATE targets that
> have child tables.  All child tables are listed in the ExecRowMark list,
> but the executor just skips the ones that didn't produce the current row.
>
> Curiously, this longstanding restriction doesn't seem to have been documented
> anywhere; so no doc changes.

It was documented on the TODO list;  marked as done now.

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

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

pgsql-committers by date:

Previous
From: mha@postgresql.org (Magnus Hagander)
Date:
Subject: pgsql: Don't pass strings directly to errdetail() and errhint() - use %s
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Fix breakage of bitmap scan plan creation for special index