pgsql: Fix dumping of FUNCTION RTEs that contain non-function-call expr

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix dumping of FUNCTION RTEs that contain non-function-call expr
Date: 2017-07-13 23:25:20
Message-ID: E1dVnU0-0000Yj-8A@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix dumping of FUNCTION RTEs that contain non-function-call expressions.

The grammar will only accept something syntactically similar to a function
call in a function-in-FROM expression. However, there are various ways
to input something that ruleutils.c won't deparse that way, potentially
leading to a view or rule that fails dump/reload. Fix by inserting a
dummy CAST around anything that isn't going to deparse as a function
(which is one of the ways to get something like that in there in the
first place).

In HEAD, also make use of the infrastructure added by this to avoid
emitting unnecessary parentheses in CREATE INDEX deparsing. I did
not change that in back branches, thinking that people might find it
to be unexpected/unnecessary behavioral change.

In HEAD, also fix incorrect logic for when to add extra parens to
partition key expressions. Somebody apparently thought they could
get away with simpler logic than pg_get_indexdef_worker has, but
they were wrong --- a counterexample is PARTITION BY LIST ((a[1])).
Ignoring the prettyprint flag for partition expressions isn't exactly
a nice solution anyway.

This has been broken all along, so back-patch to all supported branches.

Discussion: https://postgr.es/m/10477.1499970459@sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/a3ca72ae9ac14acb2b1b9cd207ac0c8a01f1439a

Modified Files
--------------
src/backend/utils/adt/ruleutils.c | 77 +++++++++++++++++++++++++++---
src/test/regress/expected/create_table.out | 2 +-
src/test/regress/expected/create_view.out | 26 ++++++++++
src/test/regress/sql/create_view.sql | 12 +++++
4 files changed, 110 insertions(+), 7 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Heikki Linnakangas 2017-07-14 13:06:54 pgsql: Fix pg_basebackup output to stdout on Windows.
Previous Message Alvaro Herrera 2017-07-13 22:17:31 pgsql: Fix typo in v10 release notes