Re: Expression index can get an empty generated column name

Chauhan Dhruv <chauhandhruv351(at)gmail(dot)com> writes:
> If you CREATE INDEX on an expression without naming the index, Postgres
> generates a name for the index column from that expression. For some
> expressions the generated name comes out empty, so the index column is
> left with an empty attname.

> Example (a whole-row reference):

> CREATE TABLE t (a int, b int);
> CREATE INDEX ON t ((t IS NOT NULL));

Hmm, yeah, that's not great, although I'd argue that the real issue in
this particular example is that we should treat the whole-row Var as
being named "t" rather than being ignored. Still, installing a
fallback of "expr" isn't a bad idea.

regards, tom lane