Error: expression index attribute is not yet supported

[mtmacdonald]

Follows on from #2206 and may be a duplicate of #2250 (I will let you decide and merge or close one duplicate if they are the same issue).

I am trying to run my team's existing PostgreSQL migrations to evaluate if Doltgres can work for our product.

I hit this blocker: error: expression index attribute is not yet supported.

To reproduce:

CREATE DATABASE testdb;
CREATE TABLE t (a TEXT);
CREATE INDEX i ON t (lower(a));

-> error: expression index attribute is not yet supported.

This does work:

CREATE INDEX i ON t (a);

Is it possible to support this so I can run our pre-existing migration scripts? Thank you!

[timsehn]

@fulghum is adding support for this right now in bothe Dolt and Doltgres. It is indeed a duplicate but I'll let him close it and make sure this test case is included.

[fulghum]

Thanks for opening this issue. Awesome to hear you are testing out your existing Postgres scripts to see if Doltgres can work for your product!

I got a very early prototype of function expressions in secondary indexes working in Dolt yesterday. There's still a lot more to implement, and Doltgres will require some more work on top of that, but wanted to let you know we're making progress.

We'll have another progress update for you next week and let you know how things are coming along.