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

Commit13cb5bd

Browse files
author
Amit Kapila
committed
Remove extra semicolon in postgres_fdw tests.
Author: Suraj KharageReviewed-by: Bharath Rupireddy, Vignesh CDiscussion:https://postgr.es/m/CAF1DzPWRfxUeH-wShz7P_pK5Tx6M_nEK+TkS8gn5ngvg07Q5=g@mail.gmail.com
1 parent9f45631 commit13cb5bd

File tree

2 files changed

+4
-4
lines changed

2 files changed

+4
-4
lines changed

‎contrib/postgres_fdw/expected/postgres_fdw.out

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -8782,8 +8782,8 @@ INSERT INTO pagg_tab_p2 SELECT i % 30, i % 50, to_char(i/30, 'FM0000') FROM gene
87828782
INSERT INTO pagg_tab_p3 SELECT i % 30, i % 50, to_char(i/30, 'FM0000') FROM generate_series(1, 3000) i WHERE (i % 30) < 30 and (i % 30) >= 20;
87838783
-- Create foreign partitions
87848784
CREATE FOREIGN TABLE fpagg_tab_p1 PARTITION OF pagg_tab FOR VALUES FROM (0) TO (10) SERVER loopback OPTIONS (table_name 'pagg_tab_p1');
8785-
CREATE FOREIGN TABLE fpagg_tab_p2 PARTITION OF pagg_tab FOR VALUES FROM (10) TO (20) SERVER loopback OPTIONS (table_name 'pagg_tab_p2');;
8786-
CREATE FOREIGN TABLE fpagg_tab_p3 PARTITION OF pagg_tab FOR VALUES FROM (20) TO (30) SERVER loopback OPTIONS (table_name 'pagg_tab_p3');;
8785+
CREATE FOREIGN TABLE fpagg_tab_p2 PARTITION OF pagg_tab FOR VALUES FROM (10) TO (20) SERVER loopback OPTIONS (table_name 'pagg_tab_p2');
8786+
CREATE FOREIGN TABLE fpagg_tab_p3 PARTITION OF pagg_tab FOR VALUES FROM (20) TO (30) SERVER loopback OPTIONS (table_name 'pagg_tab_p3');
87878787
ANALYZE pagg_tab;
87888788
ANALYZE fpagg_tab_p1;
87898789
ANALYZE fpagg_tab_p2;

‎contrib/postgres_fdw/sql/postgres_fdw.sql

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2538,8 +2538,8 @@ INSERT INTO pagg_tab_p3 SELECT i % 30, i % 50, to_char(i/30, 'FM0000') FROM gene
25382538

25392539
-- Create foreign partitions
25402540
CREATE FOREIGN TABLE fpagg_tab_p1 PARTITION OF pagg_tab FORVALUESFROM (0) TO (10) SERVER loopback OPTIONS (table_name'pagg_tab_p1');
2541-
CREATE FOREIGN TABLE fpagg_tab_p2 PARTITION OF pagg_tab FORVALUESFROM (10) TO (20) SERVER loopback OPTIONS (table_name'pagg_tab_p2');;
2542-
CREATE FOREIGN TABLE fpagg_tab_p3 PARTITION OF pagg_tab FORVALUESFROM (20) TO (30) SERVER loopback OPTIONS (table_name'pagg_tab_p3');;
2541+
CREATE FOREIGN TABLE fpagg_tab_p2 PARTITION OF pagg_tab FORVALUESFROM (10) TO (20) SERVER loopback OPTIONS (table_name'pagg_tab_p2');
2542+
CREATE FOREIGN TABLE fpagg_tab_p3 PARTITION OF pagg_tab FORVALUESFROM (20) TO (30) SERVER loopback OPTIONS (table_name'pagg_tab_p3');
25432543

25442544
ANALYZE pagg_tab;
25452545
ANALYZE fpagg_tab_p1;

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp