Hello!
I've just gotten PostgreSQL 7.0.3 to build and actually run under
WinNT 4.0, and the regression tests show two problems: one probably
minor in horology (I suppose there's a wrong time zone somewhere), and
one probably major in alter_table. I attached the diff output.
I'm not very pleased with having to run PostgreSQL on NT, but these
are the facts I can't change. So, keep up the good work!
Yours,
--
Christian Ullrich Registrierter Linux-User #125183
"Sie können nach R'ed'mond fliegen -- aber Sie werden sterben"
*** expected/horology.out Tue Mar 21 05:59:14 2000
--- results/horology.out Sun Dec 3 14:06:49 2000
***************
*** 235,243 ****
| Wed Mar 15 08:14:01 2000 PST | @ 34 years | Tue Mar 15
08:14:01 1966 PST
| Sun Dec 31 17:32:01 2000 PST | @ 34 years | Sat Dec 31
17:32:01 1966 PST
| Mon Jan 01 17:32:01 2001 PST | @ 34 years | Sun Jan 01
17:32:01 1967 PST
! | epoch | @ 5 mons 12 hours | Thu Jul 31
05:00:00 1969 PDT
! | epoch | @ 5 mons | Thu Jul 31
17:00:00 1969 PDT
! | epoch | @ 3 mons | Tue Sep 30
17:00:00 1969 PDT
| epoch | @ 10 days | Sun Dec 21
16:00:00 1969 PST
| epoch | @ 1 day 2 hours 3 mins 4 secs | Tue Dec 30
13:56:56 1969 PST
| epoch | @ 5 hours | Wed Dec 31
11:00:00 1969 PST
--- 235,243 ----
| Wed Mar 15 08:14:01 2000 PST | @ 34 years | Tue Mar 15
08:14:01 1966 PST
| Sun Dec 31 17:32:01 2000 PST | @ 34 years | Sat Dec 31
17:32:01 1966 PST
| Mon Jan 01 17:32:01 2001 PST | @ 34 years | Sun Jan 01
17:32:01 1967 PST
! | epoch | @ 5 mons 12 hours | Thu Jul 31
04:00:00 1969 PST
! | epoch | @ 5 mons | Thu Jul 31
16:00:00 1969 PST
! | epoch | @ 3 mons | Tue Sep 30
16:00:00 1969 PST
| epoch | @ 10 days | Sun Dec 21
16:00:00 1969 PST
| epoch | @ 1 day 2 hours 3 mins 4 secs | Tue Dec 30
13:56:56 1969 PST
| epoch | @ 5 hours | Wed Dec 31
11:00:00 1969 PST
***************
*** 1159,1165 ****
| Sat 01 Jan 17:32:01 2000 PST
| Sun 31 Dec 17:32:01 2000 PST
| Mon 01 Jan 17:32:01 2001 PST
! | Thu 13 Jun 00:00:00 1957 PDT
(67 rows)
SELECT '' AS eight, f1 AS european_postgres FROM ABSTIME_TBL;
--- 1159,1165 ----
| Sat 01 Jan 17:32:01 2000 PST
| Sun 31 Dec 17:32:01 2000 PST
| Mon 01 Jan 17:32:01 2001 PST
! | Thu 13 Jun 00:00:00 1957 PST
(67 rows)
SELECT '' AS eight, f1 AS european_postgres FROM ABSTIME_TBL;
***************
*** 1247,1253 ****
| 2000-01-01 17:32:01-08
| 2000-12-31 17:32:01-08
| 2001-01-01 17:32:01-08
! | 1957-06-13 00:00:00-07
(67 rows)
SELECT '' AS eight, f1 AS european_iso FROM ABSTIME_TBL;
--- 1247,1253 ----
| 2000-01-01 17:32:01-08
| 2000-12-31 17:32:01-08
| 2001-01-01 17:32:01-08
! | 1957-06-13 00:00:00-08
(67 rows)
SELECT '' AS eight, f1 AS european_iso FROM ABSTIME_TBL;
***************
*** 1335,1341 ****
| 01/01/2000 17:32:01.00 PST
| 31/12/2000 17:32:01.00 PST
| 01/01/2001 17:32:01.00 PST
! | 13/06/1957 00:00:00.00 PDT
(67 rows)
SELECT '' AS eight, f1 AS european_sql FROM ABSTIME_TBL;
--- 1335,1341 ----
| 01/01/2000 17:32:01.00 PST
| 31/12/2000 17:32:01.00 PST
| 01/01/2001 17:32:01.00 PST
! | 13/06/1957 00:00:00.00 PST
(67 rows)
SELECT '' AS eight, f1 AS european_sql FROM ABSTIME_TBL;
----------------------
*** expected/alter_table.out Tue Mar 14 23:06:55 2000
--- results/alter_table.out Sun Dec 3 14:10:54 2000
***************
*** 99,274 ****
--
VACUUM ANALYZE tenk1;
ALTER TABLE tenk1 RENAME TO ten_k;
-- 20 values, sorted
SELECT unique1 FROM ten_k WHERE unique1 < 20;
! unique1
! ---------
! 0
! 1
! 2
! 3
! 4
! 5
! 6
! 7
! 8
! 9
! 10
! 11
! 12
! 13
! 14
! 15
! 16
! 17
! 18
! 19
! (20 rows)
!
-- 20 values, sorted
SELECT unique2 FROM ten_k WHERE unique2 < 20;
! unique2
! ---------
! 0
! 1
! 2
! 3
! 4
! 5
! 6
! 7
! 8
! 9
! 10
! 11
! 12
! 13
! 14
! 15
! 16
! 17
! 18
! 19
! (20 rows)
!
-- 100 values, sorted
SELECT hundred FROM ten_k WHERE hundred = 50;
! hundred
! ---------
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! 50
! (100 rows)
!
ALTER TABLE ten_k RENAME TO tenk1;
-- 5 values, sorted
SELECT unique1 FROM tenk1 WHERE unique1 < 5;
! unique1
! ---------
! 0
! 1
! 2
! 3
! 4
! (5 rows)
!
-- FOREIGN KEY CONSTRAINT adding TEST
CREATE TABLE tmp2 (a int primary key);
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'tmp2_pkey' for table
'tmp2'
--- 99,124 ----
--
VACUUM ANALYZE tenk1;
ALTER TABLE tenk1 RENAME TO ten_k;
+ ERROR: renamerel: unable to rename tenk1.1 to ten_k.1: error 0
-- 20 values, sorted
SELECT unique1 FROM ten_k WHERE unique1 < 20;
! ERROR: Relation 'ten_k' does not exist
-- 20 values, sorted
SELECT unique2 FROM ten_k WHERE unique2 < 20;
! ERROR: Relation 'ten_k' does not exist
-- 100 values, sorted
SELECT hundred FROM ten_k WHERE hundred = 50;
! ERROR: Relation 'ten_k' does not exist
ALTER TABLE ten_k RENAME TO tenk1;
+ ERROR: Relation 'ten_k' does not exist
-- 5 values, sorted
SELECT unique1 FROM tenk1 WHERE unique1 < 5;
! NOTICE: mdopen: couldn't open tenk1: No such file or directory
! NOTICE: RelationIdBuildRelation: smgropen(tenk1): error 0
! NOTICE: mdopen: couldn't open tenk1: No such file or directory
! NOTICE: mdopen: couldn't open tenk1: No such file or directory
! NOTICE: mdopen: couldn't open tenk1: No such file or directory
! ERROR: cannot open relation tenk1
-- FOREIGN KEY CONSTRAINT adding TEST
CREATE TABLE tmp2 (a int primary key);
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'tmp2_pkey' for table
'tmp2'
----------------------
