From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | daveh(at)insightdist(dot)com (David Hartwig) |
Cc: | andreas(dot)zeugswetter(at)telecom(dot)at, hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] Core dump in regression tests. |
Date: | 1998-09-01 18:40:19 |
Message-ID: | 199809011840.OAA05599@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> > 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(at)candle(dot)pha(dot)pa(dot)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)
From | Date | Subject | |
---|---|---|---|
Next Message | Keith Parks | 1998-09-01 21:20:31 | Re: [HACKERS] Core dump in regression tests.u |
Previous Message | Michael Reifenberger | 1998-09-01 18:20:17 | 2 Troubles with (current) pgsql 6.4 (fwd) |