I did 'gmake distclean' and rebuild and I still get the attached failures.
Chris
parallel group (13 tests): text name char varchar boolean oid int8 int2 float4 int4 float8 bit numeric boolean ... ok char ... ok name ... ok varchar ... ok text ... ok int2 ... ok int4 ... ok int8 ... ok oid ... ok float4 ... ok float8 ... ok bit ... ok numeric ... ok test strings ... ok test numerology ... ok parallel group (20 tests): comments lseg time timetz circle reltime path tinterval abstime point box polygon inet type_sanity timestamptz timestamp date oidjoins interval opr_sanity point ... ok lseg ... ok box ... ok path ... ok polygon ... ok circle ... ok date ... ok time ... ok timetz ... ok timestamp ... ok timestamptz ... ok interval ... ok abstime ... ok reltime ... ok tinterval ... ok inet ... ok comments ... ok oidjoins ... ok type_sanity ... ok opr_sanity ... ok test geometry ... ok test horology ... ok test insert ... ok test create_function_1 ... ok test create_type ... ok test create_table ... ok test create_function_2 ... ok test copy ... ok parallel group (7 tests): create_operator create_aggregate vacuum triggers constraints inherit create_misc constraints ... ok triggers ... FAILED create_misc ... ok create_aggregate ... ok create_operator ... ok inherit ... ok vacuum ... ok parallel group (2 tests): create_view create_index create_index ... ok create_view ... ok test sanity_check ... ok test errors ... ok test select ... ok parallel group (18 tests): select_distinct_on select_into random update namespace select_distinct btree_index hash_index select_having select_implicit case aggregates union subselect arrays join portals transactions select_into ... ok select_distinct ... ok select_distinct_on ... ok select_implicit ... ok select_having ... ok subselect ... ok union ... ok case ... ok join ... ok aggregates ... ok transactions ... ok random ... ok portals ... ok arrays ... ok btree_index ... ok hash_index ... ok update ... ok namespace ... ok test privileges ... ok test misc ... ok parallel group (5 tests): portals_p2 select_views cluster foreign_key rules select_views ... ok portals_p2 ... ok rules ... ok foreign_key ... ok cluster ... ok parallel group (14 tests): limit prepare sequence rowtypes truncate polymorphism copy2 without_oid temp conversion domain rangefuncs alter_table plpgsql limit ... ok plpgsql ... ok copy2 ... FAILED temp ... ok domain ... FAILED rangefuncs ... ok prepare ... ok without_oid ... ok conversion ... ok truncate ... ok alter_table ... FAILED sequence ... ok polymorphism ... ok rowtypes ... ok test stats ... ok test tablespace ... ok
*** ./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 ---- ======================================================================
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly