autogenerated index name already taken

I just had a situation, where I wanted to create a second (partial + unique) index for a column that already has an index. Postico autogenerates a name, but since I already created a reqular index for the same column and the partial/unique-ness isn't reflected in the generated index name, the names clash.

Since postgres autogenerates an index name anyway, why submit one at all? Is this not true for all PG versions? Otherwise Postico should check if the name will clash and change the generated name.


No file, test, or entry point is named in the issue. Start by locating Postico's PostgreSQL index-creation flow and determine whether generated names are submitted or left to PostgreSQL; done means resolving the name collision for regular and partial/unique indexes across supported PostgreSQL versions.

Written by the indexing model from the issue text.