summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPavan Deolasee2015-06-25 02:50:21 +0000
committerPavan Deolasee2015-06-25 02:50:21 +0000
commitba61eebcd657b312cc12f0623a91966617f9ea8a (patch)
treec09e5cd988ffa1829102b36122d78976dacb3c93
parent01368b13a5d958275dcff8d0d133f9d4bdbcf50f (diff)
Fix expected output for the test case 'xc_sequence'
We no longer display NOTICEs about implicit sequence creation
-rw-r--r--src/test/regress/expected/xc_sequence.out2
1 files changed, 0 insertions, 2 deletions
diff --git a/src/test/regress/expected/xc_sequence.out b/src/test/regress/expected/xc_sequence.out
index 222519102d..5ba8bf9c14 100644
--- a/src/test/regress/expected/xc_sequence.out
+++ b/src/test/regress/expected/xc_sequence.out
@@ -99,7 +99,6 @@ DROP SEQUENCE xc_sequence_2;
-- Columns with SERIAL
-- Serial sequence is named xc_sequence_tab1_col2_seq
CREATE TABLE xc_sequence_tab1 (col1 int, col2 serial) DISTRIBUTE BY ROUNDROBIN;
-NOTICE: CREATE TABLE will create implicit sequence "xc_sequence_tab1_col2_seq" for serial column "xc_sequence_tab1.col2"
-- Some data
INSERT INTO xc_sequence_tab1 VALUES (1, DEFAULT);
INSERT INTO xc_sequence_tab1 VALUES (2, DEFAULT);
@@ -145,7 +144,6 @@ COMMIT;
DROP TABLE xc_sequence_tab1;
-- Need to recreate here, serial column is no more
CREATE TABLE xc_sequence_tab1 (col1 int, col2 serial) DISTRIBUTE BY ROUNDROBIN;
-NOTICE: CREATE TABLE will create implicit sequence "xc_sequence_tab1_col2_seq" for serial column "xc_sequence_tab1.col2"
INSERT INTO xc_sequence_tab1 VALUES (1234, DEFAULT);
SELECT col1, col2 FROM xc_sequence_tab1 ORDER BY 1;
col1 | col2