diff options
| author | Robert Haas <rhaas@postgresql.org> | 2017-12-05 13:12:00 -0500 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2017-12-05 13:12:00 -0500 |
| commit | 82c5c533d1f55dfbf3eacc61aff64fedc8915d78 (patch) | |
| tree | e5a42d90d95dd40046860b6689a50830b91b6e65 /contrib/postgres_fdw/sql/postgres_fdw.sql | |
| parent | ab3f008a2dc364cf7fb75de0a691fb0c61586c8e (diff) | |
| download | postgresql-82c5c533d1f55dfbf3eacc61aff64fedc8915d78.tar.gz postgresql-82c5c533d1f55dfbf3eacc61aff64fedc8915d78.zip | |
postgres_fdw: Fix failing regression test.
Commit ab3f008a2dc364cf7fb75de0a691fb0c61586c8e broke this.
Report by Stephen Frost.
Discussion: http://postgr.es/m/20171205180342.GO4628@tamriel.snowman.net
Diffstat (limited to 'contrib/postgres_fdw/sql/postgres_fdw.sql')
| -rw-r--r-- | contrib/postgres_fdw/sql/postgres_fdw.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/contrib/postgres_fdw/sql/postgres_fdw.sql b/contrib/postgres_fdw/sql/postgres_fdw.sql index 1df1e3aad0c..3c3c5c705f6 100644 --- a/contrib/postgres_fdw/sql/postgres_fdw.sql +++ b/contrib/postgres_fdw/sql/postgres_fdw.sql @@ -560,7 +560,7 @@ SELECT ft5, ft5.c1, ft5.c2, ft5.c3, ft4.c1, ft4.c2 FROM ft5 left join ft4 on ft5 SELECT ft5, ft5.c1, ft5.c2, ft5.c3, ft4.c1, ft4.c2 FROM ft5 left join ft4 on ft5.c1 = ft4.c1 WHERE ft4.c1 BETWEEN 10 and 30 ORDER BY ft5.c1, ft4.c1; -- check join pushdown in situations where multiple userids are involved -CREATE ROLE regress_view_owner; +CREATE ROLE regress_view_owner SUPERUSER; CREATE USER MAPPING FOR regress_view_owner SERVER loopback; GRANT SELECT ON ft4 TO regress_view_owner; GRANT SELECT ON ft5 TO regress_view_owner; |