gmake check result
template1=# select version();
version
-------------------------------------------------------------------------------
PostgreSQL 8.0.0rc1 on hppa2.0w-hp-hpux11.00, compiled by GCC gcc (GCC)
3.3.1
(1 row)
1 of 96 tests failed
test stats ... FAILED
Please find attached
src/test/regress/regression.out
src/test/regress/regression.diffs
BTW, as mentioned the other day I had to do configure as
configure LIBS="-ltermcap" ...
>From my previous mail
I have successfully compiled and installed 7.4.5 yesterday.
After doing 'make' I saw the line "Ready to install".
template1=# select version();
version
--------------------------------------------------------
PostgreSQL 7.4.5 on hppa2.0w-hp-hpux11.00, compiled by GCC gcc (GCC)
3.3.1
(1 row)
But when I started psql it immediately core dumped with
libreadline.sl.5 Unresolved external: tgetent
I did a search on the mailing list archives and got 63 hits on
'tgetent',
dating from 1997 to 2004, all having the same problem,
the missing '-ltermcap' in LIBS in src/Makefile.global.
After distclean and doing configure LIBS="-ltermcap" ...
and make again it finally worked.
In http://archives.postgresql.org/pgsql-bugs/2001-09/msg00023.php
Peter Eisentraut writes
> LIBS = -lz -lresolv -lcompat -lm -lutil -ltermcap -lreadline
That's a good fix.
The current CVS tip also works around this problem.
But the 7.4.5 src/Makefile.global still has this:
LIBS = -lz -lreadline -lPW -lgen -lBSD -ldld -lnsl -lm
So it appears this fix must have been lost anywhere.
And it is not fixed in 8.0.0rc1.
8.0.0rc1 src/Makefile.global still has this:
LIBS = -lz -lreadline -lPW -lgen -lBSD -ldld -lnsl -lm
Regards, Christoph*** ./expected/stats.out Sat Nov 1 04:18:20 2003
--- ./results/stats.out Wed Dec 15 13:57:14 2004
***************
*** 8,14 ****
SHOW stats_start_collector; -- must be on
stats_start_collector
-----------------------
! on
(1 row)
-- save counters
--- 8,14 ----
SHOW stats_start_collector; -- must be on
stats_start_collector
-----------------------
! off
(1 row)
-- save counters
***************
*** 62,68 ****
WHERE st.relname='tenk2' AND cl.relname='tenk2';
?column? | ?column? | ?column? | ?column?
----------+----------+----------+----------
! t | t | t | t
(1 row)
SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks + cl.relpages,
--- 62,68 ----
WHERE st.relname='tenk2' AND cl.relname='tenk2';
?column? | ?column? | ?column? | ?column?
----------+----------+----------+----------
! f | f | f | f
(1 row)
SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks + cl.relpages,
***************
*** 71,77 ****
WHERE st.relname='tenk2' AND cl.relname='tenk2';
?column? | ?column?
----------+----------
! t | t
(1 row)
-- clean up
--- 71,77 ----
WHERE st.relname='tenk2' AND cl.relname='tenk2';
?column? | ?column?
----------+----------
! f | f
(1 row)
-- clean up
======================================================================
parallel group (13 tests): boolean char varchar name text int2 int8 int4 oid float4 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): point box lseg path polygon circle timetz date time comments inet tinterval reltime
intervalabstime timestamp timestamptz type_sanity oidjoins 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 triggers vacuum constraints inherit create_misc
constraints ... ok
triggers ... ok
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_into select_distinct_on select_implicit select_having union case select_distinct
updaterandom arrays transactions join aggregates hash_index namespace portals btree_index subselect
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 cluster select_views rules foreign_key
select_views ... ok
portals_p2 ... ok
rules ... ok
foreign_key ... ok
cluster ... ok
parallel group (14 tests): limit copy2 temp truncate sequence domain polymorphism conversion prepare rangefuncs
rowtypeswithout_oid alter_table plpgsql
limit ... ok
plpgsql ... ok
copy2 ... ok
temp ... ok
domain ... ok
rangefuncs ... ok
prepare ... ok
without_oid ... ok
conversion ... ok
truncate ... ok
alter_table ... ok
sequence ... ok
polymorphism ... ok
rowtypes ... ok
test stats ... FAILED
test tablespace ... ok