pgsql: Improve representation of PlanRowMark.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Improve representation of PlanRowMark.
Дата
Msg-id E1YXHEH-0003rS-8z@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Improve representation of PlanRowMark.

This patch fixes two inadequacies of the PlanRowMark representation.

First, that the original LockingClauseStrength isn't stored (and cannot be
inferred for foreign tables, which always get ROW_MARK_COPY).  Since some
PlanRowMarks are created out of whole cloth and don't actually have an
ancestral RowMarkClause, this requires adding a dummy LCS_NONE value to
enum LockingClauseStrength, which is fairly annoying but the alternatives
seem worse.  This fix allows getting rid of the use of get_parse_rowmark()
in FDWs (as per the discussion around commits 462bd95705a0c23b and
8ec8760fc87ecde0), and it simplifies some things elsewhere.

Second, that the representation assumed that all child tables in an
inheritance hierarchy would use the same RowMarkType.  That's true today
but will soon not be true.  We add an "allMarkTypes" field that identifies
the union of mark types used in all a parent table's children, and use
that where appropriate (currently, only in preprocess_targetlist()).

In passing fix a couple of minor infelicities left over from the SKIP
LOCKED patch, notably that _outPlanRowMark still thought waitPolicy
is a bool.

Catversion bump is required because the numeric values of enum
LockingClauseStrength can appear in on-disk rules.

Extracted from a much larger patch to support foreign table inheritance;
it seemed worth breaking this out, since it's a separable concern.

Shigeru Hanada and Etsuro Fujita, somewhat modified by me

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/7b8b8a43317e9e59eca8b511b714a0ab7da5f1cb

Modified Files
--------------
contrib/postgres_fdw/postgres_fdw.c       |    8 +++--
src/backend/nodes/copyfuncs.c             |    4 ++-
src/backend/nodes/outfuncs.c              |    4 ++-
src/backend/optimizer/plan/planner.c      |   53 +++++++++++++++++------------
src/backend/optimizer/prep/prepsecurity.c |   33 ++++--------------
src/backend/optimizer/prep/preptlist.c    |    8 ++---
src/backend/optimizer/prep/prepunion.c    |    5 +++
src/backend/parser/analyze.c              |   36 +++++++++++++-------
src/backend/tcop/utility.c                |   22 +++++-------
src/backend/utils/adt/ruleutils.c         |    5 +++
src/include/catalog/catversion.h          |    2 +-
src/include/nodes/lockoptions.h           |    1 +
src/include/nodes/plannodes.h             |   10 ++++--
src/include/parser/analyze.h              |    2 +-
14 files changed, 108 insertions(+), 85 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Move LockClauseStrength, LockWaitPolicy into new file nodes/lock
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Replace insertion sort in contrib/intarray with qsort().