.NET 9 Postgres Compatability

[euandmj]

Hi. I have been using this project extensively with great success. However recently when upgrading a project to .NET 9 (and npgsql packages to 9.x) i have started seeing that DbUpdateExceptions are no longer wrapped by the expected UniqueConstraintException anymore.

I can see that EntityFrameworkCore.Exceptions.PostgreSQL v8.1.3 does not target .net 9.

@Giorgi do you expect breaking changes in .NET 9 Npgsql?

I will build a demo app to test properly now. And would be happy to investigate the library and look for potential compatability fixes with .net9 - would you have any pointers as to where to start?

[euandmj]

I have tested in a demo app and everything is working as intended on .net9 with .net9 npgql libs.

Error must be in the application.

Thank you.