Make check fails on 8.3.7
От | Christine Desmuke |
---|---|
Тема | Make check fails on 8.3.7 |
Дата | |
Msg-id | 4A7247FB.8050106@kshs.org обсуждение исходный текст |
Ответы |
Re: Make check fails on 8.3.7
Re: Make check fails on 8.3.7 |
Список | pgsql-general |
I'm trying to install 8.3.7, but can't get past make check. CentOS release 4.7 (Final), with an existing install of 8.3.1 running as a warm standby $ eval ./configure `pg_config --configure` $ gmake == All of PostgreSQL successfully made. Ready to install. $ gmake check Everything looks ok until it actually starts the tests: ./pg_regress --temp-install=./tmp_check --top-builddir=../../.. --srcdir=/home/postgres/postgresql-8.3.7/src/test/regress --temp-port=55432 --schedule=./parallel_schedule --multibyte=SQL_ASCII --load-language=plpgsql ============== creating temporary installation ============== ============== initializing database system ============== ============== starting postmaster ============== running on port 55432 with pid 16296 ============== creating database "regression" ============== CREATE DATABASE ALTER DATABASE ============== installing plpgsql ============== CREATE LANGUAGE ============== running regression test queries ============== parallel group (17 tests): boolean char name varchar text int2 int4 oid float4 uuid float8 txid money bit int8 enum numeric boolean ... FAILED char ... FAILED name ... ok varchar ... FAILED text ... FAILED int2 ... FAILED int4 ... FAILED int8 ... FAILED oid ... FAILED float4 ... FAILED float8 ... FAILED bit ... FAILED numeric ... FAILED txid ... FAILED uuid ... FAILED enum ... FAILED money ... ok test strings ... FAILED test numerology ... ok parallel group (18 tests): point lseg box path polygon circle time date tinterval timetz comments reltime abstime tstypes inet interval timestamptz timestamp point ... FAILED lseg ... FAILED box ... FAILED path ... FAILED polygon ... FAILED circle ... FAILED date ... FAILED time ... FAILED timetz ... FAILED timestamp ... FAILED and so on ... 83 of 114 tests failed. Samples from the regression.diffs: *** ./expected/boolean.out Fri Jun 1 18:40:19 2007 --- ./results/boolean.out Thu Jul 30 19:16:33 2009 *************** *** 75,83 **** (1 row) SELECT ' tru e '::text::boolean AS invalid; -- error - ERROR: invalid input syntax for type boolean: " tru e " SELECT ''::text::boolean AS invalid; -- error - ERROR: invalid input syntax for type boolean: "" CREATE TABLE BOOLTBL1 (f1 bool); INSERT INTO BOOLTBL1 (f1) VALUES (bool 't'); INSERT INTO BOOLTBL1 (f1) VALUES (bool 'True'); --- 75,81 ---- *************** *** 136,142 **** -- For pre-v6.3 this evaluated to false - thomas 1997-10-23 INSERT INTO BOOLTBL2 (f1) VALUES (bool 'XXX'); - ERROR: invalid input syntax for type boolean: "XXX" -- BOOLTBL2 should be full of false's at this point SELECT '' AS f_4, BOOLTBL2.* FROM BOOLTBL2; f_4 | f1 --- 134,139 ---- ====================================================================== *** ./expected/tablespace.out Thu Jul 30 19:16:15 2009 --- ./results/tablespace.out Thu Jul 30 19:16:58 2009 *************** *** 48,54 **** ALTER INDEX testschema.anindex SET TABLESPACE testspace; INSERT INTO testschema.atable VALUES(3); -- ok INSERT INTO testschema.atable VALUES(1); -- fail (checks index) - ERROR: duplicate key value violates unique constraint "anindex" SELECT COUNT(*) FROM testschema.atable; -- checks heap count ------- --- 48,53 ---- *************** *** 57,69 **** -- Will fail with bad path CREATE TABLESPACE badspace LOCATION '/no/such/location'; - ERROR: could not set permissions on directory "/no/such/location": No such file or directory -- No such tablespace CREATE TABLE bar (i int) TABLESPACE nosuchspace; - ERROR: tablespace "nosuchspace" does not exist -- Fail, not empty DROP TABLESPACE testspace; - ERROR: tablespace "testspace" is not empty DROP SCHEMA testschema CASCADE; NOTICE: drop cascades to table testschema.atable NOTICE: drop cascades to table testschema.asexecute --- 56,65 ---- It looks in every case like the ERROR (and also HINT lines) lines are causing the failures, but I'm not sure what setting I messed up to cause that. What should I be looking for? Thanks. -- Christine Desmuke Kansas Historical Society cdesmuke@kshs.org
В списке pgsql-general по дате отправления:
Предыдущее
От: "Daniel Verite"Дата:
Сообщение: Re: pg_config --sharedir points to the wrong folder.. is this a problem?