Thread: BUG #18494: hstore data type not recognized by Npgsql in PostgreSQL 16.3
BUG #18494: hstore data type not recognized by Npgsql in PostgreSQL 16.3
From
PG Bug reporting form
Date:
The following bug has been logged on the website: Bug reference: 18494 Logged by: baran kurtbogan Email address: barankurtbogan@gmail.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.
Re: BUG #18494: hstore data type not recognized by Npgsql in PostgreSQL 16.3
From
Pierre Forstmann
Date:
This does not look like a PostgreSQL error message but instead a Npgsql error message (I cannot find something similar in PG 16.3 source code).
You should create an issue for Npgsql project: https://github.com/npgsql/npgsql/issues
Le mar. 4 juin 2024 à 17:11, PG Bug reporting form <noreply@postgresql.org> a écrit :
The following bug has been logged on the website:
Bug reference: 18494
Logged by: baran kurtbogan
Email address: barankurtbogan@gmail.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.
Re: BUG #18494: hstore data type not recognized by Npgsql in PostgreSQL 16.3
From
Baran Kurtboğan
Date:
Thank you for your answer.
Pierre Forstmann <pierre.forstmann@gmail.com>, 4 Haz 2024 Sal, 19:09 tarihinde şunu yazdı:
This does not look like a PostgreSQL error message but instead a Npgsql error message (I cannot find something similar in PG 16.3 source code).You should create an issue for Npgsql project: https://github.com/npgsql/npgsql/issuesLe mar. 4 juin 2024 à 17:11, PG Bug reporting form <noreply@postgresql.org> a écrit :The following bug has been logged on the website:
Bug reference: 18494
Logged by: baran kurtbogan
Email address: barankurtbogan@gmail.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.