diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2019-06-12 19:42:38 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2019-06-12 19:43:09 -0400 |
| commit | f95d8f81062a7afa00fa034022724734a1ff5e60 (patch) | |
| tree | e1c5a95227bb4fb61944c2da5fb1a26607d7a573 /contrib/postgres_fdw/postgres_fdw.c | |
| parent | e23338cec4fb088235f27949c4f298b9738877d9 (diff) | |
| download | postgresql-f95d8f81062a7afa00fa034022724734a1ff5e60.tar.gz postgresql-f95d8f81062a7afa00fa034022724734a1ff5e60.zip | |
Fix incorrect printing of queries with duplicated join names.
Given a query in which multiple JOIN nodes used the same alias
(which'd necessarily be in different sub-SELECTs), ruleutils.c
would assign the JOIN nodes distinct aliases for clarity ...
but then it forgot to print the modified aliases when dumping
the JOIN nodes themselves. This results in a dump/reload hazard
for views, because the emitted query is flat-out incorrect:
Vars will be printed with table names that have no referent.
This has been wrong for a long time, so back-patch to all supported
branches.
Philip Dubé
Discussion: https://postgr.es/m/CY4PR2101MB080246F2955FF58A6ED1FEAC98140@CY4PR2101MB0802.namprd21.prod.outlook.com
Diffstat (limited to 'contrib/postgres_fdw/postgres_fdw.c')
0 files changed, 0 insertions, 0 deletions