Re: \d+ fails on index on partition

2018-09-27 Thread Tom Lane
Justin Pryzby writes: > pg_get_partition_constraintdef() doesn't like being passed a relkind='I', It'll also fall over if the passed OID isn't a relation at all, which is also very much not-nice for SQL-exposed inquiry functions. I'm inclined to fix this by (1) inventing an lsyscache function t

\d+ fails on index on partition

2018-09-27 Thread Justin Pryzby
For indices inherited from relkind=p: pryzbyj=# CREATE TABLE tt(i int)PARTITION BY RANGE(i); pryzbyj=# CREATE TABLE tt1 PARTITION OF tt DEFAULT; pryzbyj=# CREATE INDEX ON tt((0+i)); pryzbyj=# ALTER INDEX tt1_expr_idx ALTER COLUMN 1 SET STATISTICS 123; pryzbyj=# \d+ tt1_expr_idx ERROR: 42809: "tt