Re: [HACKERS] LinuxPPC problems

> Here is current status.
>
>                         FreeBSD         LinuxPPC(-O0)   LinuxPPC(-O2)
>
>  constraints            GOOD            NG              NG
>  create_function1       GOOD            GOOD            GOOD
>  create_function2       GOOD            GOOD            GOOD
>  select_having          GOOD            GOOD            GOOD
>  select_views           GOOD            NG              NG
>  triggers               GOOD            GOOD            GOOD
>
> After Bruce's, fix 4 NGs in LinuxPPC(-O2) turned to GOOD. Also, -O0
> and -O2 now show same results. Excellent!  Thanks Bruce.

Ah, by Tatsuo's measures I'm getting similar results on Linux/i686 as he
is getting on Linux/PPC. I have failures on constraints and
select_index, but neither are core dumps, and both involve not finding
tables (probably index or index cache corruption on pg_class). The other
regression tests which fail are due to tables or information missing
from the tests listed by Tatsuo or myself.

btw, I'm pretty sure that the select_views problem pre-dates the OID and
index patches.

David made the recent observation that my symptoms are likely due to a
damaged index, not a damaged pg_class table. So indices (or something
related) are still suspect. Remember that at least one of my symptoms is
from a table which had been destroyed and then recreated. Don't know if
that is relevant...

The only thing I haven't done yet to refresh source code is to pull a
*completely new* cvs tree from postgresql.org. However, since I'm
getting the same results as Tatsuo I think CVSup is treating me OK, so
won't try that (yet).

Off to work now.

                       - Tom