*** ./expected/triggers.out	Wed Oct 13 09:22:31 2004
--- ./results/triggers.out	Thu Apr 14 09:38:13 2005
***************
*** 307,315 ****
  NOTICE:  trigger_func() called: action = UPDATE, when = AFTER, level = STATEMENT
  -- COPY should fire per-row and per-statement INSERT triggers
  COPY main_table (a, b) FROM stdin;
  NOTICE:  trigger_func() called: action = INSERT, when = BEFORE, level = STATEMENT
  NOTICE:  trigger_func() called: action = INSERT, when = AFTER, level = STATEMENT
- SELECT * FROM main_table ORDER BY a, b;
   a  | b  
  ----+----
    6 | 10
--- 307,315 ----
  NOTICE:  trigger_func() called: action = UPDATE, when = AFTER, level = STATEMENT
  -- COPY should fire per-row and per-statement INSERT triggers
  COPY main_table (a, b) FROM stdin;
+ SELECT * FROM main_table ORDER BY a, b;
  NOTICE:  trigger_func() called: action = INSERT, when = BEFORE, level = STATEMENT
  NOTICE:  trigger_func() called: action = INSERT, when = AFTER, level = STATEMENT
   a  | b  
  ----+----
    6 | 10

======================================================================

*** ./expected/copy2.out	Tue Mar 15 10:54:54 2005
--- ./results/copy2.out	Thu Apr 14 09:38:38 2005
***************
*** 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	Tue Mar 15 10:54:54 2005
--- ./results/domain.out	Thu Apr 14 09:38:39 2005
***************
*** 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	Tue Mar 15 10:54:54 2005
--- ./results/alter_table.out	Thu Apr 14 09:38:42 2005
***************
*** 844,851 ****
  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 
  ---+---
--- 844,849 ----

======================================================================