Re: BUG #18796: Npgsql Driver: Foreign Key Read Inversion in INSERT Operations - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #18796: Npgsql Driver: Foreign Key Read Inversion in INSERT Operations
Date
Msg-id CAKFQuwYFLLXQZZZak7oWHXxh6_jT2qNNBergdQ+dixNQs3remA@mail.gmail.com
Whole thread Raw
In response to BUG #18796: Npgsql Driver: Foreign Key Read Inversion in INSERT Operations  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
On Wednesday, February 5, 2025, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      18796
Logged by:          Iza Souza
Email address:      rujjinjakka@rocketmail.com
PostgreSQL version: 16.0
Operating system:   Windows
Description:       

I'm noticing that the key is being read in reverse order in the ORM. It's
not matching what's happening in the table. I'm going to be forced to delete
a foreign key that was created correctly, but is not being read correctly.
The table was created by the Ngpsql driver in a C# API. It was created
correctly - along with the foreign keys. I can insert via SQL, but the ORM
can't insert into what it created itself, I'm on .NET 8 and I can't migrate
to .NET 9. What can I do? Create navigation? The FK was created and is
working... at least for Postgres;


The people who develop that driver are not part of the core PostgreSQL community for whom this bug reporting list is intended.  You will probably want to find out where they have setup their own support community and post this issue there.

David J.
 

pgsql-bugs by date:

Previous
From: David Steele
Date:
Subject: Bug in recovery of drop database?
Next
From: Thomas Munro
Date:
Subject: Re: BUG #18146: Rows reappearing in Tables after Auto-Vacuum Failure in PostgreSQL on Windows