-
Notifications
You must be signed in to change notification settings - Fork 874
Closed as not planned
Description
I'm getting the following error when trying to work with an hstore data type in PostgreSQL 16.3, while it was working fine in PostgreSQL 16.1:
Exception message:
The field 'xxx' has a type currently unknown to Npgsql (OID 17521). You can retrieve it as a string by marking it as unknown, please see the FAQ.
Since the same operations were working in 16.1, I had to downgrade my version from 16.3 to 16.1 to avoid this issue. Data should be read and written without any issues using the hstore data type.
Steps to reproduce
- Setup a PostgreSQL 16.3 database.
- Create a table with an
hstoredata type field. - Try to read and write data using the
hstorefield in your .NET 7 project. - Observe the error.
Further technical details
Npgsql version: Npgsql.EntityFrameworkCore.PostgreSQL 7.0.4
PostgreSQL version: 16.3 (issue present), 16.1 (works fine)
Operating system: macOS 14.5 (23F79)
Platform: Dotnet 7
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels