Bruce Momjian <maillist@candle.pha.pa.us>
>
> > Thomas A. Szybist <szybist@boxhill.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 you try:
>
> select * from pg_index;
>
> Crashes here. Not good.
Looks OK here!!
template1=> select * from pg_index;
indexrelid|indrelid|indproc| indkey|
indclass|indisclustered|indislossy|indhaskeytype|indisunique|indpred
----------+--------+-------+----------------+----------------------+------------
--+----------+-------------+-----------+-------
17061| 1249| 0| 1 2 0 0 0 0 0 0| 427 1181 0 0 0 0 0 0|f
|f |t |f |
17064| 1249| 0| 1 6 0 0 0 0 0 0| 427 421 0 0 0 0 0 0|f
|f |t |f |
17067| 1249| 0| 1 0 0 0 0 0 0 0| 427 0 0 0 0 0 0 0|f
|f |t |f |
17070| 1255| 0|-2 0 0 0 0 0 0 0| 427 0 0 0 0 0 0 0|f
|f |t |f |
17073| 1255| 0|1 7 10 0 0 0 0 0|1181 421 435 0 0 0 0 0|f
|f |t |f |
17076| 1255| 0|15 0 0 0 0 0 0 0| 431 0 0 0 0 0 0 0|f
|f |t |f |
17079| 1247| 0|-2 0 0 0 0 0 0 0| 427 0 0 0 0 0 0 0|f
|f |t |f |
17082| 1247| 0| 1 0 0 0 0 0 0 0| 1181 0 0 0 0 0 0 0|f
|f |t |f |
17085| 1259| 0|-2 0 0 0 0 0 0 0| 427 0 0 0 0 0 0 0|f
|f |t |f |
17088| 1259| 0| 1 0 0 0 0 0 0 0| 1181 0 0 0 0 0 0 0|f
|f |t |f |
17091| 1215| 0| 1 0 0 0 0 0 0 0| 427 0 0 0 0 0 0 0|f
|f |t |f |
17094| 1216| 0| 1 0 0 0 0 0 0 0| 427 0 0 0 0 0 0 0|f
|f |t |f |
17097| 1219| 0| 1 0 0 0 0 0 0 0| 427 0 0 0 0 0 0 0|f
|f |t |f |
17100| 17051| 0| 1 0 0 0 0 0 0 0| 427 0 0 0 0 0 0 0|f
|f |t |f |
(14 rows)
template1=>