*** 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' ----------------------