Dots in the schema name causes ArgumentException while creating a collation

[eymentopcuoglu]

Hi!

We would like to speed up our case-insensitive queries using collations. We are using HasCollation() in OnModelCreating(). But the problem is that our schema names include dots, which causes ArgumentException:

efcore.pg/src/EFCore.PG/Metadata/PostgresCollation.cs

Line 134 in 5aa5336

// Yes, this doesn't support dots in the schema/collation name, let somebody complain first.

Is using a different separator in your plans?

Thanks in advance!

[roji]

I'll try to take a look at this for 7.0.

[eymentopcuoglu]

Thank you! I would love to help if I can!

[roji]

Duplicate of #2495

[roji]

I looked into this, and the right way to fix this is to redo the annotations as per #2495. I did some work in this direction, but was unfortunately blocked by the lack of value tuple support in EF Core's C# literal code generation (dotnet/efcore#29383).

It may be possible to hack around with another solution, but given that time is very short and it's easy to work around this with SQL in the migration, I'm punting it for 8.0 - but will do this quite soon there.