You are viewing a single comment's thread.

view the rest of the comments →

0
0

[–] PuttItOut ago 

That is the library we use to access PostgreSQL. And I will try this among some other things to see what combo will work.

I don't know if I'll have time until tomorrow though.

0
1

[–] logos_ethos 0 points 1 point (+1|-0) ago  (edited ago)

OK. I looked in the source code, and it has a map for citext in src/EFCore.PG/Storage/Internal/NpgsqlEFTypeMapper.cs. But without public in the search_path, then the server sends the schema name too, and the code probably does not handle that.

OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.HasPostgresExtension("citext"); } might be required too. I am not sure. A bug report might suggest that this is automatic and only required if citext was not there when the connection was first made.

I am installing Visual Studio on a VM with 1GB of RAM, and it is taking forever. But after that, I might be able to tweak things.