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