[Postgres] error: could not find public.table_name index index_name column id 0

[mikestefanello]

An index with any conversion on it (ie, lower, least, etc) will cause the generation to fail:

error: could not find public.table_name index index_name column id 0

[kenshaw]

@mikestefanello Appreciate you finding this. To simplify things for the xo devs (ie, me), could you share a simplified create enum and the conversion you're using on the column with the corresponding create table statement? Much appreciated.

[mikestefanello]

CREATE UNIQUE INDEX on my_table USING BTREE (some_id, lower(title)) WHERE archived_at IS NULL;

CREATE UNIQUE INDEX ON my_table ( LEAST( one_id, another_id ), GREATEST( one_id, another_id ), typ );

[kenshaw]

@mikestefanello Thanks. I'll look into this and try to get it fixed.

[SC4RECOIN]

any work-around for this?