Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #18494: hstore data type not recognized by Npgsql in PostgreSQL 16.3 - Mailing list pgsql-bugs

From Pierre Forstmann
Subject Re: BUG #18494: hstore data type not recognized by Npgsql in PostgreSQL 16.3
Date
Msg-id CAM-sOH_Jzd5kCdMydoaHKX9vpijf2tb8mKBfBSjn9z71Qw9z4Q@mail.gmail.com
Whole thread Raw
In response to BUG #18494: hstore data type not recognized by Npgsql in PostgreSQL 16.3  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18494: hstore data type not recognized by Npgsql in PostgreSQL 16.3
List pgsql-bugs
Tree view
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.

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Visibility of a local variable
Next
From: Tom Lane
Date:
Subject: Re: Visibility of a local variable