Hi together, keep on the nice work!
On SuSE 8.0,
> uname -a
Linux dell 2.4.18-4GB #1 Wed Mar 27 13:57:05 UTC 2002 i686 unknown
During compile I got the following warning:
gcc -g -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
-Wmissing-declarations -I../../../src/include -D_GNU_SOURCE -c trigger.c -o
trigger.o
/tmp/ccgcppC9.s: Assembler messages:
/tmp/ccgcppC9.s:2014: Warning: using `%si' instead of `%esi' due to `w' suffix
/tmp/ccgcppC9.s:2014: Warning: using `%ax' instead of `%eax' due to `w' suffix
> as -v
GNU assembler version 2.11.92.0.10 (i486-suse-linux) using BFD version
2.11.92.0.10 20011021 (SuSE)
> gcc -v
Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs
gcc version 2.95.3 20010315 (SuSE)
I get the this failure (...something to do with the change to winter time last
night?):
test horology ... FAILED, diff follows.
Bye,
Tilo
> cat src/test/regress/regression.diffs
*** ./expected/horology.out Thu Sep 25 08:58:06 2003
--- ./results/horology.out Sun Oct 26 22:54:56 2003
***
*** 583,595
SELECT (timestamp with time zone 'today' = (timestamp with time zone
'tomorrow' - interval '1 day')) as "True";
True
--
! t
(1 row)
SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone
'yesterday' + interval '2 days')) as "True";
True
--
! t
(1 row)
SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
--- 583,595
SELECT (timestamp with time zone 'today' = (timestamp with time zone
'tomorrow' - interval '1 day')) as "True";
True
--
! f
(1 row)
SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone
'yesterday' + interval '2 days')) as "True";
True
--
! f
(1 row)
SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
***
*** 836,842
+ interval '02:01' AS time with time zone) AS time) AS
"03:31:00";
03:31:00
--
! 03:31:00
(1 row)
SELECT CAST(cast(date 'today' + time with time zone '03:30'
--- 836,842
+ interval '02:01' AS time with time zone) AS time) AS
"03:31:00";
03:31:00
--
! 02:31:00
(1 row)
SELECT CAST(cast(date 'today' + time with time zone '03:30'
==
*** ./expected/random.out Thu Feb 13 06:24:04 2003
--- ./results/random.outSun Oct 26 22:55:01 2003
***
*** 25,31
GROUP BY random HAVING count(random) > 1;
random | count
+---
! (0 rows)
SELECT random FROM RANDOM_TBL
WHERE random NOT BETWEEN 80 AND 120;
--- 25,32
GROUP BY random HAVING count(random) > 1;
random | count
+---
! 113 | 2
! (1 row)
SELECT random FROM RANDOM_TBL
WHERE random NOT BETWEEN 80 AND 120;
==
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
