Regression failures on freebsd
I did 'gmake distclean' and rebuild and I still get the attached failures.
Chris
Attachments:
regression.diffstext/plain; name=regression.diffsDownload
*** ./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 ----
======================================================================
On Thu, Apr 14, 2005 at 09:52:11AM +0800, Christopher Kings-Lynne wrote:
I did 'gmake distclean' and rebuild and I still get the attached failures.
Do you build in a separate directory? I do and I do have problems when
the grammars (main or plpgsql) get updated -- not sure why the derived
files from bison and flex don't get rebuilt. I just delete them by
hand. (The build directory I just rm -fr as a whole).
Yours doesn't seem like a problem in grammars, but who knows.
What I do is
cd $source_dir
for i in `find . -name .cvsignore`; do
pushd `dirname $i`
rm `cat .cvsignore`
popd
done
--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Si quieres ser creativo, aprende el arte de perder el tiempo"
Do you build in a separate directory? I do and I do have problems when
the grammars (main or plpgsql) get updated -- not sure why the derived
files from bison and flex don't get rebuilt. I just delete them by
hand. (The build directory I just rm -fr as a whole).Yours doesn't seem like a problem in grammars, but who knows.
No, I do a normal in-place build.
Chris
On Thu, Apr 14, 2005 at 09:52:11AM +0800, Christopher Kings-Lynne wrote:
I did 'gmake distclean' and rebuild and I still get the attached failures.
What versions of PostgreSQL and FreeBSD? The FreeBSD machines in
the buildfarm look good.
http://www.pgbuildfarm.org/cgi-bin/show_status.pl
If you're using CVS, have you tried with a fresh checkout? What
command do you run when you update? If you have a ~/.cvsrc, what's
in it? Do you update into a distclean'ed directory, or into one
that still has an old build in it?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/