Re: [HACKERS] Core dump in regression tests.

Bruce Momjian wrote:

> > Thomas A. Szybist <szybist(at)boxhill(dot)com>
> > >
> > > >
> > > > If I compile backend/catalog with -O2 then the table creation is
> > > ^^^
> > > > OK. So it looks like it may be indexing.c, even with Bruce's
> > > > recent fixes.
> > >
> > > Do you mean -O0 here?
> > >
> >
> > Yes, a typo, I used -O0 for this dir.
>
> Can we try a simple -O rather than just -O2 and -O0. Could this be some
> type of optimizer bug in gcc2/Solaris?
>
> Everything is pointing to indexing.c, from both the initdb failure and
> the create function failure. But I can't see anything wrong in there,
> and other platforms seem to be OK.
>

Bruce,

I do not know if this problem is related in any way, but I have a serious
problem on AIX 4.1. I am jumping in here because there is a chance they are
related. Just manifest differently.

If I add an index to a table I can no longer use the table. In essence,
the look up on relname in pg_class fails. If I:
SELECT * FROM pg_class WHERE relname = 'table_i_just_indexed'
-- or \d table_i_just_indexed
I get no results.
SELECT * FROM pg_class
Displays it perfectly. So does:
SELECT * FROM pg_class WHERE relname like '%table_i_just_indexed'
If I manually correct relname:
UPDATE pg_class SET relname = 'table_i_just_indexed' WHERE relname like
'%table_i_just_indexed'
Everything seems to function normally again.

I can not reproduce on my Linux box. Assertions show nothing. This can't be
good.

Andreas, are you having any success?