X Tutup
Skip to content

hstore data type not recognized by Npgsql in PostgreSQL #5743

@devbaran

Description

@devbaran

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

  1. Setup a PostgreSQL 16.3 database.
  2. Create a table with an hstore data type field.
  3. Try to read and write data using the hstore field in your .NET 7 project.
  4. 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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      X Tutup