Re: [HACKERS] Core dump in regression tests.

> > 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.

Wow, this is terribly frustrating.  All these problems, and I can't
reproduce any of them here.

I sure hope they all have one cause, and I hope we find the cause soon.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)