Subject: more regression test info re:hpux port

From: Daniel Simmons <[email-masked]>
Date: Sat, 19 Mar 1994 17:16:37 -0700

>Notice that the two files for which I got a permission denied message
>are the only files in the directory that are read-write to owner
>only...  By the way, both postgres and my account (from which I ran
>the regression tests) are in group admin.  I'm wondering if just
>changing those files to be writeable by group admin would fix the
>problem.  I don't really have a clue as to what is going on here,
>though (haven't read much about the inversion file system yet).  So, I
>thought I'd see what your input was on the matter.

Well, I decided that it was pretty stupid of me to not just change
those permissions and try it.  So, I did and the regression tests
went to completion.  There are still some funny looking differences
that come out of checkdiff.  Here's a new copy of my checkdiff output.

Danny
-------
Daniel Simmons          electronic mail : [email-masked]
Idaho State University       voice mail : (208) 236-3199
Computer Center              snail mail : Box 8037, Pocatello

------------------cut here--------------------------
< |             | Sun Jan 14 03:14:21 1973 PST|
> |             | Sun Jan 14 03:14:21 1973 MST|
< |             | Tue Feb 15 11:00:04 1994 PST|
> |             | Sat Mar 19 16:55:55 1994 MST|
< |             | Mon May 10 23:59:12 1943 PDT|
> |             | Mon May 10 23:59:12 1943 MST|
< |             | Thu Mar 07 10:00:00 1946 PST|
> |             | Thu Mar 07 10:00:00 1946 MST|
< |             | Wed Dec 31 15:59:59 1969 PST|
> |             | Wed Dec 31 16:59:59 1969 MST|
< |             | Sun Jan 14 03:14:21 1973 PST|
> |             | Sun Jan 14 03:14:21 1973 MST|
< |             | Tue Feb 15 11:00:04 1994 PST|
> |             | Sat Mar 19 16:55:55 1994 MST|
< |             | Mon May 10 23:59:12 1943 PDT|
> |             | Mon May 10 23:59:12 1943 MST|
< |             | Thu Mar 07 10:00:00 1946 PST|
> |             | Thu Mar 07 10:00:00 1946 MST|
< |             | Wed Dec 31 15:59:59 1969 PST|
> |             | Wed Dec 31 16:59:59 1969 MST|
< |             | Sun Jan 14 03:14:21 1973 PST|
> |             | Sun Jan 14 03:14:21 1973 MST|
< |             | Tue Feb 15 11:00:04 1994 PST|
> |             | Sat Mar 19 16:55:55 1994 MST|
< |             | Mon May 10 23:59:12 1943 PDT|
> |             | Mon May 10 23:59:12 1943 MST|
< |             | Thu Mar 07 10:00:00 1946 PST|
> |             | Thu Mar 07 10:00:00 1946 MST|
< |             | Wed Dec 31 15:59:59 1969 PST|
> |             | Wed Dec 31 16:59:59 1969 MST|
< |             | Sun Jan 14 03:14:21 1973 PST|
> |             | Sun Jan 14 03:14:21 1973 MST|
< |             | Tue Feb 15 11:00:04 1994 PST|
> |             | Sat Mar 19 16:55:55 1994 MST|
< |             | Thu Mar 07 10:00:00 1946 PST|
> |             | Thu Mar 07 10:00:00 1946 MST|
< |             | Wed Dec 31 15:59:59 1969 PST|
> |             | Wed Dec 31 16:59:59 1969 MST|
< |             | Mon May 10 23:59:12 1943 PDT|
> |             | Mon May 10 23:59:12 1943 MST|
< |             | Thu Mar 07 10:00:00 1946 PST|
> |             | Thu Mar 07 10:00:00 1946 MST|
< |             | Wed Dec 31 15:59:59 1969 PST|
> |             | Wed Dec 31 16:59:59 1969 MST|
< |             | Sun Jan 14 03:14:21 1973 PST|
> |             | Sun Jan 14 03:14:21 1973 MST|
< |             | Mon May 10 23:59:12 1943 PDT|
> |             | Mon May 10 23:59:12 1943 MST|
< |             | Thu Mar 07 10:00:00 1946 PST|
> |             | Thu Mar 07 10:00:00 1946 MST|
< |             | Wed Dec 31 15:59:59 1969 PST|
> |             | Wed Dec 31 16:59:59 1969 MST|
< |             | Sun Jan 14 03:14:21 1973 PST|
> |             | Sun Jan 14 03:14:21 1973 MST|
< |             | Tue Feb 15 11:00:04 1994 PST|
> |             | Sat Mar 19 16:55:55 1994 MST|
< |             | Thu Mar 07 10:00:00 1946 PST|
> |             | Thu Mar 07 10:00:00 1946 MST|
< |             | Wed Dec 31 15:59:59 1969 PST|
> |             | Wed Dec 31 16:59:59 1969 MST|
< |             | Sun Jan 14 03:14:21 1973 PST|
> |             | Sun Jan 14 03:14:21 1973 MST|
< |             | Mon May 10 23:59:12 1943 PDT|
> |             | Mon May 10 23:59:12 1943 MST|
< |             | Thu Mar 07 10:00:00 1946 PST|
> |             | Thu Mar 07 10:00:00 1946 MST|
< |             | Wed Dec 31 15:59:59 1969 PST|
> |             | Wed Dec 31 16:59:59 1969 MST|
< |             | Sun Jan 14 03:14:21 1973 PST|
> |             | Sun Jan 14 03:14:21 1973 MST|
< |             | Mon May 10 23:59:12 1943 PDT|
> |             | Mon May 10 23:59:12 1943 MST|
< |             | Thu Mar 07 10:00:00 1946 PST|
> |             | Thu Mar 07 10:00:00 1946 MST|
< |             | Wed Dec 31 15:59:59 1969 PST|
> |             | Wed Dec 31 16:59:59 1969 MST|
< |             | Sun Jan 14 03:14:21 1973 PST|
> |             | Sun Jan 14 03:14:21 1973 MST|
< |             | Mon May 10 23:59:12 1943 PDT|
> |             | Mon May 10 23:59:12 1943 MST|
< |             | Thu Mar 07 10:00:00 1946 PST|
> |             | Thu Mar 07 10:00:00 1946 MST|
< |             | Wed Dec 31 15:59:59 1969 PST|
> |             | Wed Dec 31 16:59:59 1969 MST|
< |             | Sun Jan 14 03:14:21 1973 PST|
> |             | Sun Jan 14 03:14:21 1973 MST|
< |             | Mon May 10 23:59:12 1943 PDT|
> |             | Mon May 10 23:59:12 1943 MST|
< |             | Thu Mar 07 10:00:00 1946 PST|
> |             | Thu Mar 07 10:00:00 1946 MST|
< |             | Wed Dec 31 15:59:59 1969 PST|
> |             | Wed Dec 31 16:59:59 1969 MST|
< |             | Mon May 10 23:59:12 1943 PDT| @ 1 minute  |
> |             | Mon May 10 23:59:12 1943 MST| @ 1 minute  |
< |             | Thu Mar 07 10:00:00 1946 PST| @ 1 minute  |
> |             | Thu Mar 07 10:00:00 1946 MST| @ 1 minute  |
< |             | Wed Dec 31 15:59:59 1969 PST| @ 1 minute  |
> |             | Wed Dec 31 16:59:59 1969 MST| @ 1 minute  |
< |             | Mon May 10 23:59:12 1943 PDT| @ 5 hours   |
> |             | Mon May 10 23:59:12 1943 MST| @ 5 hours   |
< |             | Thu Mar 07 10:00:00 1946 PST| @ 5 hours   |
> |             | Thu Mar 07 10:00:00 1946 MST| @ 5 hours   |
< |             | Wed Dec 31 15:59:59 1969 PST| @ 5 hours   |
> |             | Wed Dec 31 16:59:59 1969 MST| @ 5 hours   |
< |             | Mon May 10 23:59:12 1943 PDT| @ 10 days   |
> |             | Mon May 10 23:59:12 1943 MST| @ 10 days   |
< |             | Thu Mar 07 10:00:00 1946 PST| @ 10 days   |
> |             | Thu Mar 07 10:00:00 1946 MST| @ 10 days   |
< |             | Wed Dec 31 15:59:59 1969 PST| @ 10 days   |
> |             | Wed Dec 31 16:59:59 1969 MST| @ 10 days   |
< |             | Mon May 10 23:59:12 1943 PDT| @ 3 months  |
> |             | Mon May 10 23:59:12 1943 MST| @ 3 months  |
< |             | Thu Mar 07 10:00:00 1946 PST| @ 3 months  |
> |             | Thu Mar 07 10:00:00 1946 MST| @ 3 months  |
< |             | Wed Dec 31 15:59:59 1969 PST| @ 3 months  |
> |             | Wed Dec 31 16:59:59 1969 MST| @ 3 months  |
< |             | Mon May 10 23:59:12 1943 PDT| @ 14 seconds ago|
> |             | Mon May 10 23:59:12 1943 MST| @ 14 seconds ago|
< |             | Thu Mar 07 10:00:00 1946 PST| @ 14 seconds ago|
> |             | Thu Mar 07 10:00:00 1946 MST| @ 14 seconds ago|
< |             | Wed Dec 31 15:59:59 1969 PST| @ 14 seconds ago|
> |             | Wed Dec 31 16:59:59 1969 MST| @ 14 seconds ago|
< |             | ['Mon May 10 23:59:12 1943 PDT' 'Sun Jan 14 03:14:21 1973 PST']|
> |             | ['Mon May 10 23:59:12 1943 MST' 'Sun Jan 14 03:14:21 1973 MST']|
< |             | ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']|
> |             | ['Sun Sep 04 23:59:12 1983 MDT' 'Tue Oct 04 23:59:12 1983 MDT']|
< |             | ['epoch' 'Tue Feb 15 11:00:08 1994 PST']|
> |             | ['epoch' 'Sat Mar 19 16:56:04 1994 MST']|
< |             | ['Thu Feb 15 12:15:03 1990 PST' 'current']|
> |             | ['Thu Feb 15 12:15:03 1990 MST' 'current']|
< |             | ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']|
> |             | ['Sun Sep 04 23:59:12 1983 MDT' 'Tue Oct 04 23:59:12 1983 MDT']|
< |             | ['Mon May 10 23:59:12 1943 PDT' 'Sun Jan 14 03:14:21 1973 PST']|
> |             | ['Mon May 10 23:59:12 1943 MST' 'Sun Jan 14 03:14:21 1973 MST']|
< |             | ['epoch' 'Tue Feb 15 11:00:08 1994 PST']|
> |             | ['epoch' 'Sat Mar 19 16:56:04 1994 MST']|
< |             | ['Thu Feb 15 12:15:03 1990 PST' 'current']|
> |             | ['Thu Feb 15 12:15:03 1990 MST' 'current']|
< |             | ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']|
> |             | ['Sun Sep 04 23:59:12 1983 MDT' 'Tue Oct 04 23:59:12 1983 MDT']|
< |             | ['Mon May 10 23:59:12 1943 PDT' 'Sun Jan 14 03:14:21 1973 PST']|
> |             | ['Mon May 10 23:59:12 1943 MST' 'Sun Jan 14 03:14:21 1973 MST']|
< |             | ['epoch' 'Tue Feb 15 11:00:08 1994 PST']|
> |             | ['epoch' 'Sat Mar 19 16:56:04 1994 MST']|
< |             | ['Thu Feb 15 12:15:03 1990 PST' 'current']|
> |             | ['Thu Feb 15 12:15:03 1990 MST' 'current']|
< |             | ['Mon May 10 23:59:12 1943 PDT' 'Sun Jan 14 03:14:21 1973 PST']|
> |             | ['Mon May 10 23:59:12 1943 MST' 'Sun Jan 14 03:14:21 1973 MST']|
< |             | ['epoch' 'Tue Feb 15 11:00:08 1994 PST']|
> |             | ['epoch' 'Sat Mar 19 16:56:04 1994 MST']|
< |             | ['Thu Feb 15 12:15:03 1990 PST' 'current']|
> |             | ['Thu Feb 15 12:15:03 1990 MST' 'current']|
< |             | ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']|
> |             | ['Sun Sep 04 23:59:12 1983 MDT' 'Tue Oct 04 23:59:12 1983 MDT']|
< |             | ['epoch' 'Tue Feb 15 11:00:08 1994 PST']|
> |             | ['epoch' 'Sat Mar 19 16:56:04 1994 MST']|
< |             | ['Mon May 10 23:59:12 1943 PDT' 'Sun Jan 14 03:14:21 1973 PST']| ['Mon May 10 23:59:12 1943 PDT' 'Sun Jan 14 03:14:21 1973 PST']|
> |             | ['Mon May 10 23:59:12 1943 MST' 'Sun Jan 14 03:14:21 1973 MST']| ['Mon May 10 23:59:12 1943 MST' 'Sun Jan 14 03:14:21 1973 MST']|
< |             | ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']| ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']|
> |             | ['Sun Sep 04 23:59:12 1983 MDT' 'Tue Oct 04 23:59:12 1983 MDT']| ['Sun Sep 04 23:59:12 1983 MDT' 'Tue Oct 04 23:59:12 1983 MDT']|
< |             | ['epoch' 'Tue Feb 15 11:00:08 1994 PST']| ['epoch' 'Tue Feb 15 11:00:08 1994 PST']|
> |             | ['epoch' 'Sat Mar 19 16:56:04 1994 MST']| ['epoch' 'Sat Mar 19 16:56:04 1994 MST']|
< |             | ['Thu Feb 15 12:15:03 1990 PST' 'current']| ['Thu Feb 15 12:15:03 1990 PST' 'current']|
> |             | ['Thu Feb 15 12:15:03 1990 MST' 'current']| ['Thu Feb 15 12:15:03 1990 MST' 'current']|
< |             | ['Mon May 10 23:59:12 1943 PDT' 'Sun Jan 14 03:14:21 1973 PST']| ['-infinity' 'infinity']|
> |             | ['Mon May 10 23:59:12 1943 MST' 'Sun Jan 14 03:14:21 1973 MST']| ['-infinity' 'infinity']|
< |             | ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']| ['-infinity' 'infinity']|
> |             | ['Sun Sep 04 23:59:12 1983 MDT' 'Tue Oct 04 23:59:12 1983 MDT']| ['-infinity' 'infinity']|
< |             | ['epoch' 'Tue Feb 15 11:00:08 1994 PST']| ['-infinity' 'infinity']|
> |             | ['epoch' 'Sat Mar 19 16:56:04 1994 MST']| ['-infinity' 'infinity']|
< |             | ['Thu Feb 15 12:15:03 1990 PST' 'current']| ['-infinity' 'infinity']|
> |             | ['Thu Feb 15 12:15:03 1990 MST' 'current']| ['-infinity' 'infinity']|
< |             | ['-infinity' 'infinity']| ['Mon May 10 23:59:12 1943 PDT' 'Sun Jan 14 03:14:21 1973 PST']|
> |             | ['-infinity' 'infinity']| ['Mon May 10 23:59:12 1943 MST' 'Sun Jan 14 03:14:21 1973 MST']|
< |             | ['epoch' 'Tue Feb 15 11:00:08 1994 PST']| ['Mon May 10 23:59:12 1943 PDT' 'Sun Jan 14 03:14:21 1973 PST']|
> |             | ['epoch' 'Sat Mar 19 16:56:04 1994 MST']| ['Mon May 10 23:59:12 1943 MST' 'Sun Jan 14 03:14:21 1973 MST']|
< |             | ['-infinity' 'infinity']| ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']|
> |             | ['-infinity' 'infinity']| ['Sun Sep 04 23:59:12 1983 MDT' 'Tue Oct 04 23:59:12 1983 MDT']|
< |             | ['epoch' 'Tue Feb 15 11:00:08 1994 PST']| ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']|
> |             | ['epoch' 'Sat Mar 19 16:56:04 1994 MST']| ['Sun Sep 04 23:59:12 1983 MDT' 'Tue Oct 04 23:59:12 1983 MDT']|
< |             | ['-infinity' 'infinity']| ['epoch' 'Tue Feb 15 11:00:08 1994 PST']|
> |             | ['-infinity' 'infinity']| ['epoch' 'Sat Mar 19 16:56:04 1994 MST']|
< |             | ['Mon May 10 23:59:12 1943 PDT' 'Sun Jan 14 03:14:21 1973 PST']| ['epoch' 'Tue Feb 15 11:00:08 1994 PST']|
> |             | ['Mon May 10 23:59:12 1943 MST' 'Sun Jan 14 03:14:21 1973 MST']| ['epoch' 'Sat Mar 19 16:56:04 1994 MST']|
< |             | ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']| ['epoch' 'Tue Feb 15 11:00:08 1994 PST']|
> |             | ['Sun Sep 04 23:59:12 1983 MDT' 'Tue Oct 04 23:59:12 1983 MDT']| ['epoch' 'Sat Mar 19 16:56:04 1994 MST']|
< |             | ['Thu Feb 15 12:15:03 1990 PST' 'current']| ['epoch' 'Tue Feb 15 11:00:08 1994 PST']|
> |             | ['Thu Feb 15 12:15:03 1990 MST' 'current']| ['epoch' 'Sat Mar 19 16:56:04 1994 MST']|
< |             | ['-infinity' 'infinity']| ['Thu Feb 15 12:15:03 1990 PST' 'current']|
> |             | ['-infinity' 'infinity']| ['Thu Feb 15 12:15:03 1990 MST' 'current']|
< |             | ['epoch' 'Tue Feb 15 11:00:08 1994 PST']| ['Thu Feb 15 12:15:03 1990 PST' 'current']|
> |             | ['epoch' 'Sat Mar 19 16:56:04 1994 MST']| ['Thu Feb 15 12:15:03 1990 MST' 'current']|
< |             | ['Mon May 10 23:59:12 1943 PDT' 'Sun Jan 14 03:14:21 1973 PST']|
> |             | ['Mon May 10 23:59:12 1943 MST' 'Sun Jan 14 03:14:21 1973 MST']|
< |             | ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']|
> |             | ['Sun Sep 04 23:59:12 1983 MDT' 'Tue Oct 04 23:59:12 1983 MDT']|
< |             | ['Thu Feb 15 12:15:03 1990 PST' 'current']|
> |             | ['Thu Feb 15 12:15:03 1990 MST' 'current']|
< |             | ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']|
> |             | ['Sun Sep 04 23:59:12 1983 MDT' 'Tue Oct 04 23:59:12 1983 MDT']|
< |             | ['epoch' 'Tue Feb 15 11:00:08 1994 PST']|
> |             | ['epoch' 'Sat Mar 19 16:56:04 1994 MST']|
< |             | 0           |
> |             | -1e-39      |
< |             | 0           |
> |             | -1e-39      |
< |             | 0           |
> |             | -1e-39      |
< |             | 0           |
> |             | -1e-39      |
< |             | 0           |
> |             | -1e-39      |
< |             | 0           |
> |             | -1e-39      |
< |             | 0           |
> |             | -1e-39      |
< |             | 0           | 0           |
> |             | -1e-39      | 1e-39       |
< |             | 0           |
> |             | -1e-39      |
< |             | 0           | -0          |
> |             | 0           | 0           |
< |             | -34.84      | -3.26607421344208|
> |             | -34.84      | 0           |
< |             | 1.2345678901234e+200| 4.97933859234765e+66|
> |             | 1.2345678901234e+200| 4.9793385923476e+66|
< |             | 1.2345678901234e-200| 2.3112042409018e-67|
> |             | 1.2345678901234e-200| 2.31120424090182e-67|
< |             | 4           | char16      | text        | 4.1         | 4.1         | 2           | (         4.1,         4.1,         3.1,         3.1)| Tue Feb 15 11:02:31 1994 PST| c           | {Tue Feb 15 11:02:31 1994 PST,Mon Aug 24 14:43:07 1992 PDT,epoch}| 314159      | (1,0,1)     | 512         | 1 2 3 4 5 6 7 8|             | magnetic disk| (1.1,1.1)   | (4.1,4.1,3.1,3.1)| (0,2,4.1,4.1,3.1,3.1)| (4.1,4.1,3.1,3.1)| ['current' 'infinity']| 1/3         | 1,char16    | {"1","2","3","4"}| {"1","2","3","4"}| {1,2,3,4}   |
> |             | 4           | char16      | text        | 4.1         | 4.1         | 2           | (         4.1,         4.1,         3.1,         3.1)| Sat Mar 19 17:03:00 1994 MST| c           | {Sat Mar 19 17:03:00 1994 MST,Mon Aug 24 15:43:07 1992 MDT,epoch}| 314159      | (1,0,1)     | 512         | 1 2 3 4 5 6 7 8|             | magnetic disk| (1.1,1.1)   | (4.1,4.1,3.1,3.1)| (0,2,4.1,4.1,3.1,3.1)| (4.1,4.1,3.1,3.1)| ['current' 'infinity']| 1/3         | 1,char16    | {"1","2","3","4"}| {"1","2","3","4"}| {1,2,3,4}   |
< |             | 4           | char16      | text        | 4.1         | 4.1         | 2           | (         4.1,         4.1,         3.1,         3.1)| Tue Feb 15 11:02:32 1994 PST| c           | {Tue Feb 15 11:02:32 1994 PST,Mon Aug 24 14:43:07 1992 PDT,epoch}| 314159      | (1,0,1)     | 512         | 1 2 3 4 5 6 7 8|             | magnetic disk| (1.1,1.1)   | (4.1,4.1,3.1,3.1)| (0,2,4.1,4.1,3.1,3.1)| (4.1,4.1,3.1,3.1)| ['current' 'infinity']| 1/3         | 1,char16    | {"1","2","3","4"}| {"1","2","3","4"}| {1,2,3,4}   |
> |             | 4           | char16      | text        | 4.1         | 4.1         | 2           | (         4.1,         4.1,         3.1,         3.1)| Sat Mar 19 17:03:07 1994 MST| c           | {Sat Mar 19 17:03:07 1994 MST,Mon Aug 24 15:43:07 1992 MDT,epoch}| 314159      | (1,0,1)     | 512         | 1 2 3 4 5 6 7 8|             | magnetic disk| (1.1,1.1)   | (4.1,4.1,3.1,3.1)| (0,2,4.1,4.1,3.1,3.1)| (4.1,4.1,3.1,3.1)| ['current' 'infinity']| 1/3         | 1,char16    | {"1","2","3","4"}| {"1","2","3","4"}| {1,2,3,4}   |
< | d_star      |
> | d_star      |
< | BOOLTBL1    |
< | BOOLTBL2    |
< | ABSTIME_TBL |
> | BOOLTBL1    |
< | RELTIME_TBL |
> | BOOLTBL2    |
< | TINTERVAL_TBL|
> | ABSTIME_TBL |
< | BOX_TBL     |
> | RELTIME_TBL |
< | CHAR_TBL    |
> | TINTERVAL_TBL|
< | CHAR2_TBL   |
> | BOX_TBL     |
> | CHAR_TBL    |
> | CHAR2_TBL   |
< | a,320258    |
> | a,1155298   |
< # /usr/local/devel/postgres-4.2-devel/src/regress/regress/RCS/sample.regress.out,v 1.11 1994/02/16 04:23:17 aoki Exp
> # /usr/local/devel/postgres-4.2-devel/src/regress/regress/RCS/fstest.source,v 1.5 1993/11/05 08:38:50 aoki Exp
< RCS
< /data1/RCS:
< dept.data,v
< emp.data,v
< hash.data,v
< onek.data,v
< person.data,v
< real_city.data,v
< rect.data,v
< streets.data,v
< stud_emp.data,v
< student.data,v
< tenk.data,v
< aportal.out
< regress.so
< so_locations
> regress.sl
< ufp1.so
> ufp1.sl
< ufp2.so
> ufp2.sl
< ufp3.so
> ufp3.sl
< aportal.out
< regress.so
< so_locations
> regress.sl
< ufp1.so
> ufp1.sl
< ufp2.so
> ufp2.sl
< ufp3.so
> ufp3.sl
< WARN:pg_ownercheck: class "nonesuch" not found
> WARN:Relation nonesuch Does Not Exist!
< WARN:pg_ownercheck: class "nonesuch" not found
> WARN:renamerel: relation "nonesuch" does not exist
< WARN:pg_ownercheck: class "nonesuch" not found
> WARN:renamerel: relation "nonesuch" does not exist
< WARN:pg_ownercheck: class "nonesuchrel" not found
> WARN:renameatt: relation "nonesuchrel" nonexistent
< WARN:pg_ownercheck: class "nonesuch" not found
> WARN:index "nonesuch" nonexistant
< WARN:pg_ownercheck: type "nonesuch" not found
> WARN:RemoveType: type "nonesuch" does not exist
< WARN:read on "myclass0": permission denied
> | a           |
> | 1           |
> | 1           |
> | 100         |
< WARN:read on "myclass0": permission denied
> REPLACE
< WARN:read on "myclass0": permission denied
> REPLACE
< WARN:read on "myclass0": permission denied
> DELETE
< WARN:define rule on "myclass0": permission denied
> DEFINE
< kill: 18776: no such process
> kill: 26262: no such process
< Async. notification on relation asynctest1a, our backend pid is 18778
> Async. notification on relation asynctest1a, our backend pid is 26264

---

From: Daniel Simmons <[email-masked]>
Date: Sat, 19 Mar 1994 19:38:27 -0700

In message <[email-masked]> you write:
>> went to completion.
>:-)  thanks.  whew.  you just lowered my stress level by about
>an order of magnitude.

Good.  I guess I would mention that some thought ought to be given to
why the permissions were wrong in the first place, though.  Maybe it
is all just the fault of bsdinst, but I don't know.

>everything looks ok (unimportant diffs) except:
>
>not good.  probably some random difference between the hpux 9.00 math 
>library (for 800s) and the 9.01 math library (for 700s).  i'll have to 
>check it out a 700 to make sure.  (i generally test on a 9000/877 
>running 9.00.)

Well, in the default configurations the 700s have math coprocessors
while the 800s do not...  One thing you have going for you, though, is
that the 877 has the same PA Risc processor (1.1) model as most of the
700s (except the new geckos and 715s).  Also, you should be aware
(if you aren't already) that there is a special pa-risc 1.1 version of
the math libraries that is only linked in if you add extra flags.  I
haven't checked how my copy of postgres 4.2 was linked, but I didn't
twiddle anything.

>this is all permission checking stuff.  could the first "bmake"
>have been done by one user and then the test run by another?
>bmaking the script sets a user-name inside of it, and if the
>user who actually *runs* the script has the postgres superuser
>(create user) permission, this can cause the behavior shown.

I ran the original bmake as postgres and the regression bmake as
simmdan.  Should I have run the original bmake as simmdan and then
changed all the ownerships?  Or, should I somehow get bmake to change
the user-name in the regression script or something?

>re: timestamps
>i think what we'll have to do is set the $%@! timezone to GMT
>in the regression script.  it's sort of evil to do that because
>then you never really exercise the daylight savings time code,
>but it's probably better than wading through a hundred lines of
>meaningless diffs.  i flip through it quickly because i know
>what to look for, but ..

Sounds like that might be a good idea.  I will say, though, that I
noticed funny time stamps in the inversion file system by doing
"pls -D regression -lsga /" while the regression tests were running.
I don't know enough about it to know whether or not the times were
supposed to be this way, but I ran it a couple of times and found a
couple of files in each case they had dates with a year 1969...

>thanks for your help in working through this.  i admire your 
>patience (i tend to be short on that, as marc can attest.. :-).

No problem.  Anything I can do to help.

Danny

-------

---

From: Daniel Simmons <[email-masked]>
Date: Sat, 19 Mar 1994 23:03:47 -0700

In message <[email-masked]> you write:
>re: linking in different math libraries.  we could do that -- i've never
>been able to keep which machines have what processors straight, though.
>it's a pain for me just to remember the business about the even/odd 
>minor revision numbers of the OS :-)  if you have a good suggestion
>i'm all ears.

Well, the odd numbers are for the 700s and the even numbers are for
the 800s, but the actual math lib you should use potentially depends
on the hardware model within the 800s, etc. (independent of the OS
version).  Basically, I'd say you are doing about the best you can
under the circumstances.

>this is what i changed in src/backend/port/hpux/Makefile.inc:
>
>*** 1.10	1993/11/06 01:05:31
>--- Makefile.inc	1994/03/20 02:56:47
>***************
>*** 16,39 ****
>  LDFLAGS+= -W l,-E
>  LDADD+= -ll -ldld
>  
>- .if (${HPUX_MAJOR} == "08")
>  #
>  # cbrt(3m) and rint(3m) are missing from the 8.07 math library.
>  #
>  CFLAGS+= -DNEED_RINT -DNEED_CBRT
>  
>- .elif (${HPUX_MAJOR} == "09")
>- #
>- # rint(3m) is broken in the 9.01 math library.
>- #
>- CFLAGS+= -DNEED_RINT
>- #
>- # 9.00 on the 800s seems to be missing cbrt(3m)
>- #
>- .if (${HPUX_MINOR} == "00")
>- CFLAGS+= -DNEED_CBRT
>- .endif
>- 
>  #
>  # The #pragma trick required on 8.07 no longer works -- the #pragma
>  # is thoroughly broken.  However, the +u flag has been extended to
>--- 16,29 ----
>  LDFLAGS+= -W l,-E
>  LDADD+= -ll -ldld
>  
>  #
>  # cbrt(3m) and rint(3m) are missing from the 8.07 math library.
>+ # rint(3m) and cbrt(3m) are broken in the 9.01 math library.
>+ # 9.00 on the 800s seems to be missing cbrt(3m) even though
>+ # it is documented.
>  #
>  CFLAGS+= -DNEED_RINT -DNEED_CBRT

I used this patch, but it created a small problem because you removed
a .if at the top without fixing the .endif which was "off the end" of
your patch.  Here's a diff (between the version after I applied your
patch and the version I ended up using) showing what I did to fix
this:

*** Makefile.inc.cln    Sat Mar 19 20:04:25 1994
--- Makefile.inc        Sat Mar 19 20:11:17 1994
***************
*** 35,40 ****
--- 35,41 ----
  # The YACC grammar is too big..
  # (HP-UX 9.01 added basic block limits for +O2.)
  #
+ .if (${HPUX_MAJOR} == "09")
  .  if !defined(CDEBUG)
  CFLAGS+= +Obb600
  .  endif

So, then I cleaned everything out and rebuilt from scratch.  Before I
did that, though, I took a look at bsdinst and discovered that there
was a commented out "rm -f" line in the bsdinst that came with X11
that said something about removing the rm so that users could install
through symbolic links.  Anyway, I copied it to ~postgres/bin and 
removed the comment:

*** /share/X11/bin/bsdinst      Fri Sep 10 10:48:03 1993
--- bsdinst     Sat Mar 19 20:13:38 1994
***************
*** 124,130 ****

  # This rm is commented out because some people want to be able to
  # install through symbolic links.  Uncomment it if it offends you.
! # rm -f $dst/$srcbase
  (cd $srcdir ; $installcmd -f $dst $flags $src)

  if [ x$dostrip = xstrip ]
--- 124,130 ----

  # This rm is commented out because some people want to be able to
  # install through symbolic links.  Uncomment it if it offends you.
! rm -f $dst/$srcbase
  (cd $srcdir ; $installcmd -f $dst $flags $src)

  if [ x$dostrip = xstrip ]

Doing this meant that the install went entirely without a hitch.

Before I ran the regression test again, I went in as simmdan and did
bmake clean all so that simmdan would own things.  While the test was
running, though, I noticed that postgres was ending up the owner of
onek.data and stud_emp.data so I changed them to be group readable and
writable from another window while the tests were running before it
got to the place near the end where it died before.  So, the tests
went to completion as well.  

I'm thinking that there's something wrong with the way the tests work,
though.  It doesn't real seem that I should have to jump through those
kinds of hoops to get them to run...

Anyway, at the end of the message is my latest checkdiff output.  It
looks like it's mostly ok, but I'll let you be the final judge.

Danny

P.S. I'm wasted.  So, I'm going home to bed.  :-) Talk to you on
     Monday or whenever you get around to it.
-------
Daniel Simmons          electronic mail : [email-masked]
Idaho State University       voice mail : (208) 236-3199
Computer Center              snail mail : Box 8037, Pocatello

-------------------cut here---------------------
> |             | Sat Mar 19 22:30:56 1994 MST|
> |             | Sat Mar 19 22:30:56 1994 MST|
> |             | Sat Mar 19 22:30:56 1994 MST|
> |             | Sat Mar 19 22:30:56 1994 MST|
> |             | Sat Mar 19 22:30:56 1994 MST|
> |             | ['epoch' 'Sat Mar 19 22:31:05 1994 MST']|
> |             | ['epoch' 'Sat Mar 19 22:31:05 1994 MST']|
> |             | ['epoch' 'Sat Mar 19 22:31:05 1994 MST']|
> |             | ['epoch' 'Sat Mar 19 22:31:05 1994 MST']|
> |             | ['epoch' 'Sat Mar 19 22:31:05 1994 MST']|
> |             | ['epoch' 'Sat Mar 19 22:31:05 1994 MST']| ['epoch' 'Sat Mar 19 22:31:05 1994 MST']|
> |             | ['epoch' 'Sat Mar 19 22:31:05 1994 MST']| ['-infinity' 'infinity']|
> |             | ['epoch' 'Sat Mar 19 22:31:05 1994 MST']| ['Mon May 10 23:59:12 1943 MST' 'Sun Jan 14 03:14:21 1973 MST']|
> |             | ['epoch' 'Sat Mar 19 22:31:05 1994 MST']| ['Sun Sep 04 23:59:12 1983 MDT' 'Tue Oct 04 23:59:12 1983 MDT']|
> |             | ['-infinity' 'infinity']| ['epoch' 'Sat Mar 19 22:31:05 1994 MST']|
> |             | ['Mon May 10 23:59:12 1943 MST' 'Sun Jan 14 03:14:21 1973 MST']| ['epoch' 'Sat Mar 19 22:31:05 1994 MST']|
> |             | ['Sun Sep 04 23:59:12 1983 MDT' 'Tue Oct 04 23:59:12 1983 MDT']| ['epoch' 'Sat Mar 19 22:31:05 1994 MST']|
> |             | ['Thu Feb 15 12:15:03 1990 MST' 'current']| ['epoch' 'Sat Mar 19 22:31:05 1994 MST']|
> |             | ['epoch' 'Sat Mar 19 22:31:05 1994 MST']| ['Thu Feb 15 12:15:03 1990 MST' 'current']|
> |             | ['epoch' 'Sat Mar 19 22:31:05 1994 MST']|
< |             | 0           |
< |             | 0           |
< |             | 0           |
< |             | 0           |
< |             | 0           |
< |             | 0           |
< |             | 0           |
< |             | 0           | 0           |
< |             | 0           |
< |             | 0           | -0          |
> |             | 4           | char16      | text        | 4.1         | 4.1         | 2           | (         4.1,         4.1,         3.1,         3.1)| Sat Mar 19 22:38:13 1994 MST| c           | {Sat Mar 19 22:38:13 1994 MST,Mon Aug 24 15:43:07 1992 MDT,epoch}| 314159      | (1,0,1)     | 512         | 1 2 3 4 5 6 7 8|             | magnetic disk| (1.1,1.1)   | (4.1,4.1,3.1,3.1)| (0,2,4.1,4.1,3.1,3.1)| (4.1,4.1,3.1,3.1)| ['current' 'infinity']| 1/3         | 1,char16    | {"1","2","3","4"}| {"1","2","3","4"}| {1,2,3,4}   |
> |             | 4           | char16      | text        | 4.1         | 4.1         | 2           | (         4.1,         4.1,         3.1,         3.1)| Sat Mar 19 22:38:19 1994 MST| c           | {Sat Mar 19 22:38:19 1994 MST,Mon Aug 24 15:43:07 1992 MDT,epoch}| 314159      | (1,0,1)     | 512         | 1 2 3 4 5 6 7 8|             | magnetic disk| (1.1,1.1)   | (4.1,4.1,3.1,3.1)| (0,2,4.1,4.1,3.1,3.1)| (4.1,4.1,3.1,3.1)| ['current' 'infinity']| 1/3         | 1,char16    | {"1","2","3","4"}| {"1","2","3","4"}| {1,2,3,4}   |
< | d_star      |
< | BOOLTBL1    |
< | BOOLTBL2    |
< | ABSTIME_TBL |
< | RELTIME_TBL |
< | TINTERVAL_TBL|
< | BOX_TBL     |
< | CHAR_TBL    |
< | CHAR2_TBL   |
< | a,320258    |
> | a,319810    |
< RCS
< /data1/RCS:
< dept.data,v
< emp.data,v
< hash.data,v
< onek.data,v
< person.data,v
< real_city.data,v
< rect.data,v
< streets.data,v
< stud_emp.data,v
< student.data,v
< tenk.data,v
< regress.so
< so_locations
< ufp1.so
< ufp2.so
< ufp3.so
< regress.so
< so_locations
< ufp1.so
< ufp2.so
< ufp3.so
> kill: 3701: no such process
> Async. notification on relation asynctest1a, our backend pid is 3703

---

From: Daniel Simmons <[email-masked]>
Date: Mon, 21 Mar 1994 08:46:37 -0700

In message <[email-masked]> you write:
>those don't have to be writable, just readable (it does a write then
>read), but the obj directory has to be writable.  i think the 
>distribution comes with 775 directories.  it should probably have 
>777 obj directories, at least in regression.

Well, they were read/write for owner only (400), and were owned by
postgres even though I was running the tests as simmdan.  It looked to
me like the files were created by the backend and therefore owned by
postgres even though the frontend was being run by simmdan.

>oddly, i've never, ever received any problem reports about file 
>permissions during the regression tests -- most people install it
>and run it as themselves, i imagine (or ignore the warning and 
>run it as postgres, causing a different problem).  i do seem to recall 
>that nfs file systems on hpux seem to have various types of braindeath 
>with respect to permissions, though.  i would mount ultrix-exported
>file systems and be told i didn't own my own files..  groups didn't
>work right and i had to make things 777..  that kind of thing.

All of this stuff is nfs mounted, but we haven't had too many problems
of the kind you mention.  I installed everything as postgres so that
it would own it all (seemed to make sense at the time).  At any rate,
I'm not going to worry about it.  It looks like everything is working
now, and if there is some small permissions problem which comes back
to haunt me later I'll worry about it then (I doubt that will happen,
though).

>looks ok to me.

Thanks so much for your help.  Now I can proceed with my project with
some amount of confidence.

Danny

-------