pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Yet further fixes for multi-row VALUES lists for updatable views
Date: Tue, 11 Oct 2022 22:24:39 +0000
Message-ID: <E1oiNfz-001xlI-1r@gemulon.postgresql.org> (raw)

Yet further fixes for multi-row VALUES lists for updatable views.

DEFAULT markers appearing in an INSERT on an updatable view
could be mis-processed if they were in a multi-row VALUES clause.
This would lead to strange errors such as "cache lookup failed
for type NNNN", or in older branches even to crashes.

The cause is that commit 41531e42d tried to re-use rewriteValuesRTE()
to remove any SetToDefault nodes (that hadn't previously been replaced
by the view's own default values) appearing in "product" queries,
that is DO ALSO queries.  That's fundamentally wrong because the
DO ALSO queries might not even be INSERTs; and even if they are,
their targetlists don't necessarily match the view's column list,
so that almost all the logic in rewriteValuesRTE() is inapplicable.

What we want is a narrow focus on replacing any such nodes with NULL
constants.  (That is, in this context we are interpreting the defaults
as being strictly those of the view itself; and we already replaced
any that aren't NULL.)  We could add still more !force_nulls tests
to further lobotomize rewriteValuesRTE(); but it seems cleaner to
split out this case to a new function, restoring rewriteValuesRTE()
to the charter it had before.

Per bug #17633 from jiye_sw.  Patch by me, but thanks to
Richard Guo and Japin Li for initial investigation.
Back-patch to all supported branches, as the previous fix was.

Discussion: https://postgr.es/m/17633-98cc85e1fa91e905@postgresql.org

Branch
------
REL_13_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/21e042b0bd47d8564f7178f72114d707cb1ceba8

Modified Files
--------------
src/backend/rewrite/rewriteHandler.c          | 84 ++++++++++++++++++---------
src/test/regress/expected/updatable_views.out | 22 +++++++
src/test/regress/sql/updatable_views.sql      | 17 ++++++
3 files changed, 97 insertions(+), 26 deletions(-)



view thread (7+ messages)  latest in thread

Message-ID: <E1oiNfz-001xlI-1r@gemulon.postgresql.org>
Permalink:  ../E1oiNfz-001xlI-1r@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1oiNfz-001xlI-1r@gemulon.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-committers@postgresql.org
  Cc: tgl@sss.pgh.pa.us
  Subject: Re: pgsql: Yet further fixes for multi-row VALUES lists for updatable views
  In-Reply-To: <E1oiNfz-001xlI-1r@gemulon.postgresql.org>
  References: <E1oiNfz-001xlI-1r@gemulon.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox