aboutsummaryrefslogtreecommitdiff
path: root/src/tutorial/advanced.source
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2021-08-07 13:29:32 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2021-08-07 13:29:32 -0400
commit2c915905e3e82b1db28dce8630f8d20b3db316f2 (patch)
tree85bbc6d8ed196e42e7d4b2152d6be96ad8ff70a5 /src/tutorial/advanced.source
parent9b0d71725eb2ca6ea0aaffdc38be599b90e7dc56 (diff)
downloadpostgresql-2c915905e3e82b1db28dce8630f8d20b3db316f2.tar.gz
postgresql-2c915905e3e82b1db28dce8630f8d20b3db316f2.zip
Really fix the ambiguity in REFRESH MATERIALIZED VIEW CONCURRENTLY.
Rather than trying to pick table aliases that won't conflict with any possible user-defined matview column name, adjust the queries' syntax so that the aliases are only used in places where they can't be mistaken for column names. Mostly this consists of writing "alias.*" not just "alias", which adds clarity for humans as well as machines. We do have the issue that "SELECT alias.*" acts differently from "SELECT alias", but we can use the same hack ruleutils.c uses for whole-row variables in SELECT lists: write "alias.*::compositetype". We might as well revert to the original aliases after doing this; they're a bit easier to read. Like 75d66d10e, back-patch to all supported branches. Discussion: https://postgr.es/m/2488325.1628261320@sss.pgh.pa.us
Diffstat (limited to 'src/tutorial/advanced.source')
0 files changed, 0 insertions, 0 deletions