> >> So what do you get from 'select * from pg_index where indrelid = 16737' ?
> >> If that crashes, which individual columns can you select from the row?
>
> > I found the exact row and column that causes the server to crash.
> > http://archives.postgresql.org/pgsql-general/2006-10/msg01320.php
>
> That didn't answer my question.
mydb=# \x
Expanded display is on.
mydb=# select * from pg_index where indrelid = 16737;
-[ RECORD 1 ]--+--------------------------
indexrelid | 604243
indrelid | 16737
indnatts | 1
indisunique | t
indisprimary | t
indisclustered | t
indkey | 1
indclass | 2039
indexprs |
indpred |
-[ RECORD 2 ]--+--------------------------
indexrelid | 604251
indrelid | 16737
indnatts | 1
indisunique | f
indisprimary | f
indisclustered | f
indkey | 0
indclass | 2039
indexprs | ({FUNCEXPR :funcid 2020 :funcresulttype 1114 :funcretset false :funcformat 0
:args ({CONST :consttype 25 :constlen -1 :constbyval false :constisnull false :constvalue 7 [ 7 0
0 0 100 97 121 ]} {VAR :varno 1 :varattno
indpred |
-[ RECORD 3 ]--+--------------------------
indexrelid | 604252
indrelid | 16737
indnatts | 1
indisunique | f
indisprimary | f
indisclustered | f
indkey | 0
indclass | 2039
indexprs | ({FUNCEXPR :funcid 2020 :funcresulttype 1114 :funcretset false :funcformat 0
:args ({CONST :consttype 25 :constlen -1 :constbyval false :constisnull false :constvalue 8 [ 8 0
0 0 104 111 117 114 ]} {VAR :varno 1 :varattno 1 :vartype 1114 :vartypmod -1 :varlevelsup 0
:varnoold 1 :varoattno 1})})
indpred |
-[ RECORD 4 ]--+--------------------------
indexrelid | 604253
indrelid | 16737
indnatts | 1
indisunique | f
indisprimary | f
indisclustered | f
indkey | 0
indclass | 2039
indexprs | ({FUNCEXPR :funcid 2020 :funcresulttype 1114 :funcretset false :funcformat 0
:args ({CONST :consttype 25 :constlen -1 :constbyval false :constisnull false :constvalue 10 [ 10
0 0 0 109 105 110 117 116 101 ]} {VAR :varno 1 :varattno 1 :vartype 1114 :vartypmod -1
:varlevelsup 0 :varnoold 1 :varoattno 1})})
indpred |
Sorry about that,
Regards,
Richard Broersma Jr.