*** ./expected/copy2.out Wed Dec 28 10:04:33 2005 --- ./results/copy2.out Sat Feb 11 23:21:12 2006 *************** *** 34,51 **** ERROR: column "d" specified more than once -- missing data: should fail COPY x from stdin; - ERROR: invalid input syntax for integer: "" - CONTEXT: COPY x, line 1, column a: "" COPY x from stdin; - ERROR: missing data for column "e" - CONTEXT: COPY x, line 1: "2000 230 23 23" COPY x from stdin; - ERROR: missing data for column "e" - CONTEXT: COPY x, line 1: "2001 231 \N \N" -- extra data: should fail COPY x from stdin; - ERROR: extra data after last expected column - CONTEXT: COPY x, line 1: "2002 232 40 50 60 70 80" -- various COPY options: delimiters, oids, NULL string COPY x (b, c, d, e) from stdin with oids delimiter ',' null 'x'; COPY x from stdin WITH DELIMITER AS ';' NULL AS ''; --- 34,43 ---- ====================================================================== *** ./expected/domain.out Mon Jan 16 13:12:32 2006 --- ./results/domain.out Sat Feb 11 23:21:13 2006 *************** *** 39,46 **** INSERT INTO basictest values ('88', 'haha', 'short', '123.1212'); -- Truncate numeric -- Test copy COPY basictest (testvarchar) FROM stdin; -- fail - ERROR: value too long for type character varying(5) - CONTEXT: COPY basictest, line 1: "notsoshorttext" COPY basictest (testvarchar) FROM stdin; select * from basictest; testint4 | testtext | testvarchar | testnumeric --- 39,44 ---- *************** *** 126,137 **** INSERT INTO nulltest values ('a', 'b', 'c', NULL, 'd'); -- Good -- Test copy COPY nulltest FROM stdin; --fail - ERROR: domain dcheck does not allow null values - CONTEXT: COPY nulltest, line 1: "a b \N d \N" -- Last row is bad COPY nulltest FROM stdin; - ERROR: new row for relation "nulltest" violates check constraint "nulltest_col5_check" - CONTEXT: COPY nulltest, line 3: "a b c \N a" select * from nulltest; col1 | col2 | col3 | col4 | col5 ------+------+------+------+------ --- 124,131 ---- ====================================================================== *** ./expected/alter_table.out Sat Feb 11 16:58:36 2006 --- ./results/alter_table.out Sat Feb 11 23:21:14 2006 *************** *** 867,874 **** copy test("........pg.dropped.1........") to stdout; ERROR: column "........pg.dropped.1........" of relation "test" does not exist copy test from stdin; - ERROR: extra data after last expected column - CONTEXT: COPY test, line 1: "10 11 12" select * from test; b | c ---+--- --- 867,872 ---- ======================================================================