BUG #18494: hstore data type not recognized by Npgsql in PostgreSQL 16.3

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: barankurtbogan(at)gmail(dot)com
Subject: BUG #18494: hstore data type not recognized by Npgsql in PostgreSQL 16.3
Date: 2024-06-04 14:46:17
Message-ID: 18494-26852f0012742688@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 18494
Logged by: baran kurtbogan
Email address: barankurtbogan(at)gmail(dot)com
PostgreSQL version: 16.3
Operating system: macOS sonoma 14.5 (23F79)
Description:

Version:

PostgreSQL 16.3,
Npgsql.EntityFrameworkCore.PostgreSQL 7.0.4 ,
Entity Framework 7.0.8

Platform: Dotnet 7

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:
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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message SAS 2024-06-04 15:22:22 Minor update on pg_hba documentation
Previous Message Andrew Bille 2024-06-04 14:22:37 Re: BUG #18463: Possible bug in stored procedures with polymorphic OUT parameters