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

From: Baran Kurtboğan <barankurtbogan(at)gmail(dot)com>
To: Pierre Forstmann <pierre(dot)forstmann(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18494: hstore data type not recognized by Npgsql in PostgreSQL 16.3
Date: 2024-06-06 07:20:47
Message-ID: CALRbEVm9Y=uQ9Y0bmsUyPxDpdtvo2boRTR-f3sSue44g3SrU2g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Thank you for your answer.

Pierre Forstmann <pierre(dot)forstmann(at)gmail(dot)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/issues
>
>
> Le mar. 4 juin 2024 à 17:11, PG Bug reporting form <noreply(at)postgresql(dot)org>
> a écrit :
>
>> 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.
>>
>>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Laurenz Albe 2024-06-06 08:10:53 Re: BUG #18477: A specific SQL query with "ORDER BY ... NULLS FIRST" is performing poorly if an ordering column is n
Previous Message PG Bug reporting form 2024-06-06 07:12:08 BUG #18496: Strange Handling for Circular Views and Permissions in PostgreSQL