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

Commitbe1d437

Browse files
committed
Forget to update the real source of the regression test results after
message editing.
1 parentfeb4f44 commitbe1d437

File tree

1 file changed

+25
-25
lines changed

1 file changed

+25
-25
lines changed

‎src/test/regress/output/constraints.source

Lines changed: 25 additions & 25 deletions
Original file line numberDiff line numberDiff line change
@@ -62,12 +62,12 @@ CREATE TABLE CHECK_TBL (x int,
6262
INSERT INTO CHECK_TBL VALUES (5);
6363
INSERT INTO CHECK_TBL VALUES (4);
6464
INSERT INTO CHECK_TBL VALUES (3);
65-
ERROR: new row for relation "check_tbl" violatesCHECK constraint "check_con"
65+
ERROR: new row for relation "check_tbl" violatescheck constraint "check_con"
6666
INSERT INTO CHECK_TBL VALUES (2);
67-
ERROR: new row for relation "check_tbl" violatesCHECK constraint "check_con"
67+
ERROR: new row for relation "check_tbl" violatescheck constraint "check_con"
6868
INSERT INTO CHECK_TBL VALUES (6);
6969
INSERT INTO CHECK_TBL VALUES (1);
70-
ERROR: new row for relation "check_tbl" violatesCHECK constraint "check_con"
70+
ERROR: new row for relation "check_tbl" violatescheck constraint "check_con"
7171
SELECT '' AS three, * FROM CHECK_TBL;
7272
three | x
7373
-------+---
@@ -82,13 +82,13 @@ CREATE TABLE CHECK2_TBL (x int, y text, z int,
8282
CHECK (x > 3 and y <> 'check failed' and z < 8));
8383
INSERT INTO CHECK2_TBL VALUES (4, 'check ok', -2);
8484
INSERT INTO CHECK2_TBL VALUES (1, 'x check failed', -2);
85-
ERROR: new row for relation "check2_tbl" violatesCHECK constraint "sequence_con"
85+
ERROR: new row for relation "check2_tbl" violatescheck constraint "sequence_con"
8686
INSERT INTO CHECK2_TBL VALUES (5, 'z check failed', 10);
87-
ERROR: new row for relation "check2_tbl" violatesCHECK constraint "sequence_con"
87+
ERROR: new row for relation "check2_tbl" violatescheck constraint "sequence_con"
8888
INSERT INTO CHECK2_TBL VALUES (0, 'check failed', -2);
89-
ERROR: new row for relation "check2_tbl" violatesCHECK constraint "sequence_con"
89+
ERROR: new row for relation "check2_tbl" violatescheck constraint "sequence_con"
9090
INSERT INTO CHECK2_TBL VALUES (6, 'check failed', 11);
91-
ERROR: new row for relation "check2_tbl" violatesCHECK constraint "sequence_con"
91+
ERROR: new row for relation "check2_tbl" violatescheck constraint "sequence_con"
9292
INSERT INTO CHECK2_TBL VALUES (7, 'check ok', 7);
9393
SELECT '' AS two, * from CHECK2_TBL;
9494
two | x | y | z
@@ -107,7 +107,7 @@ CREATE TABLE INSERT_TBL (x INT DEFAULT nextval('insert_seq'),
107107
CONSTRAINT INSERT_CON CHECK (x >= 3 AND y <> 'check failed' AND x < 8),
108108
CHECK (x + z = 0));
109109
INSERT INTO INSERT_TBL(x,z) VALUES (2, -2);
110-
ERROR: new row for relation "insert_tbl" violatesCHECK constraint "insert_con"
110+
ERROR: new row for relation "insert_tbl" violatescheck constraint "insert_con"
111111
SELECT '' AS zero, * FROM INSERT_TBL;
112112
zero | x | y | z
113113
------+---+---+---
@@ -120,13 +120,13 @@ SELECT 'one' AS one, nextval('insert_seq');
120120
(1 row)
121121

122122
INSERT INTO INSERT_TBL(y) VALUES ('Y');
123-
ERROR: new row for relation "insert_tbl" violatesCHECK constraint "insert_con"
123+
ERROR: new row for relation "insert_tbl" violatescheck constraint "insert_con"
124124
INSERT INTO INSERT_TBL(y) VALUES ('Y');
125125
INSERT INTO INSERT_TBL(x,z) VALUES (1, -2);
126-
ERROR: new row for relation "insert_tbl" violatesCHECK constraint "$1"
126+
ERROR: new row for relation "insert_tbl" violatescheck constraint "$1"
127127
INSERT INTO INSERT_TBL(z,x) VALUES (-7, 7);
128128
INSERT INTO INSERT_TBL VALUES (5, 'check failed', -5);
129-
ERROR: new row for relation "insert_tbl" violatesCHECK constraint "insert_con"
129+
ERROR: new row for relation "insert_tbl" violatescheck constraint "insert_con"
130130
INSERT INTO INSERT_TBL VALUES (7, '!check failed', -7);
131131
INSERT INTO INSERT_TBL(y) VALUES ('-!NULL-');
132132
SELECT '' AS four, * FROM INSERT_TBL;
@@ -139,9 +139,9 @@ SELECT '' AS four, * FROM INSERT_TBL;
139139
(4 rows)
140140

141141
INSERT INTO INSERT_TBL(y,z) VALUES ('check failed', 4);
142-
ERROR: new row for relation "insert_tbl" violatesCHECK constraint "$1"
142+
ERROR: new row for relation "insert_tbl" violatescheck constraint "$1"
143143
INSERT INTO INSERT_TBL(x,y) VALUES (5, 'check failed');
144-
ERROR: new row for relation "insert_tbl" violatesCHECK constraint "insert_con"
144+
ERROR: new row for relation "insert_tbl" violatescheck constraint "insert_con"
145145
INSERT INTO INSERT_TBL(x,y) VALUES (5, '!check failed');
146146
INSERT INTO INSERT_TBL(y) VALUES ('-!NULL-');
147147
SELECT '' AS six, * FROM INSERT_TBL;
@@ -162,7 +162,7 @@ SELECT 'seven' AS one, nextval('insert_seq');
162162
(1 row)
163163

164164
INSERT INTO INSERT_TBL(y) VALUES ('Y');
165-
ERROR: new row for relation "insert_tbl" violatesCHECK constraint "insert_con"
165+
ERROR: new row for relation "insert_tbl" violatescheck constraint "insert_con"
166166
SELECT 'eight' AS one, currval('insert_seq');
167167
one | currval
168168
-------+---------
@@ -193,11 +193,11 @@ CREATE TABLE INSERT_CHILD (cx INT default 42,
193193
INHERITS (INSERT_TBL);
194194
INSERT INTO INSERT_CHILD(x,z,cy) VALUES (7,-7,11);
195195
INSERT INTO INSERT_CHILD(x,z,cy) VALUES (7,-7,6);
196-
ERROR: new row for relation "insert_child" violatesCHECK constraint "insert_child_cy"
196+
ERROR: new row for relation "insert_child" violatescheck constraint "insert_child_cy"
197197
INSERT INTO INSERT_CHILD(x,z,cy) VALUES (6,-7,7);
198-
ERROR: new row for relation "insert_child" violatesCHECK constraint "$1"
198+
ERROR: new row for relation "insert_child" violatescheck constraint "$1"
199199
INSERT INTO INSERT_CHILD(x,y,z,cy) VALUES (6,'check failed',-6,7);
200-
ERROR: new row for relation "insert_child" violatesCHECK constraint "insert_con"
200+
ERROR: new row for relation "insert_child" violatescheck constraint "insert_con"
201201
SELECT * FROM INSERT_CHILD;
202202
x | y | z | cx | cy
203203
---+--------+----+----+----
@@ -227,7 +227,7 @@ SELECT '' AS three, * FROM INSERT_TBL;
227227
INSERT INTO INSERT_TBL SELECT * FROM tmp WHERE yd = 'try again';
228228
INSERT INTO INSERT_TBL(y,z) SELECT yd, -7 FROM tmp WHERE yd = 'try again';
229229
INSERT INTO INSERT_TBL(y,z) SELECT yd, -8 FROM tmp WHERE yd = 'try again';
230-
ERROR: new row for relation "insert_tbl" violatesCHECK constraint "insert_con"
230+
ERROR: new row for relation "insert_tbl" violatescheck constraint "insert_con"
231231
SELECT '' AS four, * FROM INSERT_TBL;
232232
four | x | y | z
233233
------+---+---------------+----
@@ -246,7 +246,7 @@ UPDATE INSERT_TBL SET x = NULL WHERE x = 5;
246246
UPDATE INSERT_TBL SET x = 6 WHERE x = 6;
247247
UPDATE INSERT_TBL SET x = -z, z = -x;
248248
UPDATE INSERT_TBL SET x = z, z = x;
249-
ERROR: new row for relation "insert_tbl" violatesCHECK constraint "insert_con"
249+
ERROR: new row for relation "insert_tbl" violatescheck constraint "insert_con"
250250
SELECT * FROM INSERT_TBL;
251251
x | y | z
252252
---+---------------+----
@@ -273,7 +273,7 @@ SELECT '' AS two, * FROM COPY_TBL;
273273
(2 rows)
274274

275275
COPY COPY_TBL FROM '@abs_srcdir@/data/constrf.data';
276-
ERROR: new row for relation "copy_tbl" violatesCHECK constraint "copy_con"
276+
ERROR: new row for relation "copy_tbl" violatescheck constraint "copy_con"
277277
CONTEXT: COPY FROM, line 2
278278
SELECT * FROM COPY_TBL;
279279
x | y | z
@@ -290,11 +290,11 @@ NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "primary_tbl_pkey
290290
INSERT INTO PRIMARY_TBL VALUES (1, 'one');
291291
INSERT INTO PRIMARY_TBL VALUES (2, 'two');
292292
INSERT INTO PRIMARY_TBL VALUES (1, 'three');
293-
ERROR: duplicate key violatesUNIQUE constraint "primary_tbl_pkey"
293+
ERROR: duplicate key violatesunique constraint "primary_tbl_pkey"
294294
INSERT INTO PRIMARY_TBL VALUES (4, 'three');
295295
INSERT INTO PRIMARY_TBL VALUES (5, 'one');
296296
INSERT INTO PRIMARY_TBL (t) VALUES ('six');
297-
ERROR: null valuefor attribute "i" violatesNOT NULL constraint
297+
ERROR: null valuein column "i" violatesnot-null constraint
298298
SELECT '' AS four, * FROM PRIMARY_TBL;
299299
four | i | t
300300
------+---+-------
@@ -314,7 +314,7 @@ INSERT INTO PRIMARY_TBL VALUES (1, 'three');
314314
INSERT INTO PRIMARY_TBL VALUES (4, 'three');
315315
INSERT INTO PRIMARY_TBL VALUES (5, 'one');
316316
INSERT INTO PRIMARY_TBL (t) VALUES ('six');
317-
ERROR: null valuefor attribute "i" violatesNOT NULL constraint
317+
ERROR: null valuein column "i" violatesnot-null constraint
318318
SELECT '' AS three, * FROM PRIMARY_TBL;
319319
three | i | t
320320
-------+---+-------
@@ -334,7 +334,7 @@ NOTICE: CREATE TABLE / UNIQUE will create implicit index "unique_tbl_i_key" for
334334
INSERT INTO UNIQUE_TBL VALUES (1, 'one');
335335
INSERT INTO UNIQUE_TBL VALUES (2, 'two');
336336
INSERT INTO UNIQUE_TBL VALUES (1, 'three');
337-
ERROR: duplicate key violatesUNIQUE constraint "unique_tbl_i_key"
337+
ERROR: duplicate key violatesunique constraint "unique_tbl_i_key"
338338
INSERT INTO UNIQUE_TBL VALUES (4, 'four');
339339
INSERT INTO UNIQUE_TBL VALUES (5, 'one');
340340
INSERT INTO UNIQUE_TBL (t) VALUES ('six');
@@ -358,7 +358,7 @@ INSERT INTO UNIQUE_TBL VALUES (1, 'one');
358358
INSERT INTO UNIQUE_TBL VALUES (2, 'two');
359359
INSERT INTO UNIQUE_TBL VALUES (1, 'three');
360360
INSERT INTO UNIQUE_TBL VALUES (1, 'one');
361-
ERROR: duplicate key violatesUNIQUE constraint "unique_tbl_i_key"
361+
ERROR: duplicate key violatesunique constraint "unique_tbl_i_key"
362362
INSERT INTO UNIQUE_TBL VALUES (5, 'one');
363363
INSERT INTO UNIQUE_TBL (t) VALUES ('six');
364364
SELECT '' AS five, * FROM UNIQUE_TBL;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp