SQL MERGE Patch Status

From PostgreSQL wiki
Revision as of 12:17, 30 January 2018 by Simon (talk | contribs) (Created page with "= Previous History [https://wiki.postgresql.org/wiki/SQL_MERGE] = Overview Patch for SQL Standard MERGE statement submitted to PostgreSQL core Current patch is v14 [https:/...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

= Previous History [1]

= Overview

Patch for SQL Standard MERGE statement submitted to PostgreSQL core

Current patch is v14 [2]

= Open Items

== Bugs

  • Incorrect wording on ERROR when using subselect in the SET clause of MERGE UPDATE:

Unrecognized node type 114 [3]

  • Incorrect wording on ERROR when using a whole row reference in the SET clause of MERGE UPDATE

ERROR: XX000: variable not found in subplan target lists [4]

== Minor

  • None

== Major

  • Discussion around concurrency. Should we throw ERROR if concurrent update/delete makes row unavailable after EvalPlanQual?

Unresolved request for change to earlier consensus on how to proceed [5]

= Unsupported features

  • Partitioning (WIP)
  • INSERT OVERIDING
  • Tab completion

= Not planned for PG11

  • RLS - Requested not to be supported for PG11, on basis of risk
  • Transition tables for Statement Triggers
  • RETURNING - not part of standard
  • CTE support - not part of standard

= Closed

  • Add xref docs between INSERT ON CONFLICT and MERGE (18/1/29)