Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit82c5c53

Browse files
committed
postgres_fdw: Fix failing regression test.
Commitab3f008 broke this.Report by Stephen Frost.Discussion:http://postgr.es/m/20171205180342.GO4628@tamriel.snowman.net
1 parentab3f008 commit82c5c53

File tree

2 files changed

+2
-2
lines changed

2 files changed

+2
-2
lines changed

‎contrib/postgres_fdw/expected/postgres_fdw.out

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -2315,7 +2315,7 @@ SELECT ft5, ft5.c1, ft5.c2, ft5.c3, ft4.c1, ft4.c2 FROM ft5 left join ft4 on ft5
23152315
(4 rows)
23162316

23172317
-- check join pushdown in situations where multiple userids are involved
2318-
CREATE ROLE regress_view_owner;
2318+
CREATE ROLE regress_view_owner SUPERUSER;
23192319
CREATE USER MAPPING FOR regress_view_owner SERVER loopback;
23202320
GRANT SELECT ON ft4 TO regress_view_owner;
23212321
GRANT SELECT ON ft5 TO regress_view_owner;

‎contrib/postgres_fdw/sql/postgres_fdw.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -560,7 +560,7 @@ SELECT ft5, ft5.c1, ft5.c2, ft5.c3, ft4.c1, ft4.c2 FROM ft5 left join ft4 on ft5
560560
SELECT ft5,ft5.c1,ft5.c2,ft5.c3,ft4.c1,ft4.c2FROM ft5left join ft4onft5.c1=ft4.c1WHEREft4.c1 BETWEEN10and30ORDER BYft5.c1,ft4.c1;
561561

562562
-- check join pushdown in situations where multiple userids are involved
563-
CREATE ROLE regress_view_owner;
563+
CREATE ROLE regress_view_owner SUPERUSER;
564564
CREATEUSERMAPPING FOR regress_view_owner SERVER loopback;
565565
GRANTSELECTON ft4 TO regress_view_owner;
566566
GRANTSELECTON ft5 TO regress_view_owner;

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp