[–]logos_ethos0 points
1 point
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.
[–] logos_ethos 0 points 1 point 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.