npgsql/npgsql

Npgsql is the .NET data provider for Postgresql. It allows any program developed for .NET framework to access a Postgresql database server. It is implemented in 100% C# code. Postgresql versions since 9.0 are officially supported, others may work.

James Houx

@jhouxzirrus

I think the problem must stem from the fact that it thinks I'm connecting from 192.168.1.1 -- and honestly I have no idea how it thinks that's my ip address... moreoever, if it thinks that's my IP address, I have no idea how it even sent a response back to me.

I'm on a VPN, which must be somehow causing an issue. DBeaver is accepted but Npgsql is not. hrm

Shay Rojansky

@roji

@kieranbenton don't remember any known issue with an NRE in 5.0, can you open an issue with a code sample?

James Houx

@jhouxzirrus

@roji Shay, would you have any ideas about the problem I described? I don't understand why I can connect from a database application (Dbeaver) just fine, but when I try npgsql, the database rejects it and thinks I'm connecting from 192.168.1.1 (which I'm not!). I can't figure out how this could even be a software issue..... all I have as evidence is that Dbeaver works and npgsql does not

James Houx

@jhouxzirrus

I spoke to my network engineer and he said that due to NAT translation, I really am connecting from 192.168.1.1. So that explains that. But still no idea why I can connect from Dbeaver but not npgsql

James Houx

@jhouxzirrus

@roji ok we finally got it resolved. For some reason Dbeaver must be connecting with SSL even though it says its off. We found that we had to use SSL to get a connection to accept. I added SSL to the connection string, and it fixed the problem

Schmitt Christian

@schmitch

if npgsql efcore would have a jsonb_path_match method, how would that look in c#? JsonbPathMatch(object, string, string) or would it be more like JsonbPathMatch(object, string, object) and the second object param gets translated aswell? i.e. we created a custom method translator in the form of JsonbPathMatch(object, string, string) and are looking to upstream it

usage would be as follow: .Where(p => p.JsonField, "exists($[*] ? (@.id == $id && @.value == $value))", JsonSerializer.SerializeObject())

Mats Israelsson

@mais0375

Is there a way to broadcast local net work to list postessql servers. As for MSSQL ?

Postgressql servers

stephenwood

@stephenwood

Have any of you ever had the following problem? I have a WebApi services that uses Npgsql and that runs in a Kubernetes pod. The service methods use NpgSql to execute Postgres functions. When I alter one of those functions, even if I do it in a way that does not change the function signature, the service starts failing. Restarting the pod immediately fixes the problem. Any ideas why this is happening?

Alberto Passalacqua

@AlbertoPa

I am having an issue when saving an entity with inheritance. The base entity (say A) is common to several objects. I am trying to save B, which inherits from A. However, when doing so, I get an exception because it says a non-null constraint is violated. The issue is that the null constraint is in another entity, C, which inherits from A. Has the behavior changed? This code has worked in 3.x :-?

Alberto Passalacqua

@AlbertoPa

well, this was interesting... the error was caused by a change in how IEquatable shoul be implemented... fixed now

Chuya Guo

@chuyaguo2014

Hi everyone, a newbie question about Npsql 5.0.0

I'm following this tutorial here: http://zetcode.com/csharp/postgresql/ and just using the most basic example where I have a hardcoded connection string and want to print out the version of my local postgres DB.

The program runs successfully if I use 5.0.0-preview1 but fails when I use 5.0.0 with this "Unhandled exception. System.TypeInitializationException: The type initializer for 'Npgsql.TypeMapping.GlobalTypeMapper' threw an exception. ---> System.Reflection.ReflectionTypeLoadException: Unable to load one or more of the requested types." error - could someone please point me in the right direction? How should I configure my connection string for Npsql 5.0.0? thank you very much!

Here's a screenshot of the error I see

Chuya Guo

@chuyaguo2014

and this is my dotnet version

Chuya Guo

@chuyaguo2014

ah I think I fixed this by changing my dotnet sdk version from 5.0.100 to 5.0.101 🤦🏻‍♀️😅

Björn Harrtell

@bjornharrtell

I use NpgsqlBinaryExporter but do not know the column type at compile time. Using ReadAsync<object>(npgsqlDbType) does not appear to work at all, is that known/intentional?

Björn Harrtell

@bjornharrtell

(i.e only fx. ReadAsync<int>() will work for me)

Elad

@Elad53820332_twitter

Hi, is there a way to use npgsql with .net 4.0 ?

Waldo

@waldo2188

Hi ! I use efcore.pg v3.1.4 and try to build a simple request on a List<string> attribute like explained in the doc ctx.SomeEntities.Where(e => e.SomeArray[0] == 3).ToList();. But Linq it fail with this error message "Sequence contains no elements"

Shay Rojansky

@roji

@waldo2188 we're going to need to see some code - can you post a sample on stackoverflow (tagged npgsql)?

@Elad53820332_twitter no, .NET Framework 4.0 hasn't been supported by Npgsql for a very long time (and is in fact out of support by Microsoft)

@bjornharrtell at least at the moment, you must know the types you're reading out of the COPY API. This limitation is related to how things actually work at the PostgreSQL wire protocol level.

Shay Rojansky

@roji

@schmitch sounds like you're working on jsonpath support (npgsql/efcore.pg#1045). I assume you're referring to the vars parameter, right? If so, since that's a jsonb, it should be an object just like anywhere else - this allows people to pass a JsonDocument, for example. But I suggest you open an issue describing the design you're planning before doing a full implementation, so we can discuss.

Alberto Passalacqua

@AlbertoPa

I am having issues when issuing a SaveChangesAsync() becase Sytem.Text.Json is throwing complaining about cycles even if I am using Newtonsoft on the server. Is there an option to use Newtonsoft also for EF operations?

Shay Rojansky

@roji

@AlbertoPa the EF provider only supports System.Text.Json - but there seems to be at least some support for loops/cycles: https://docs.microsoft.com/en-us/dotnet/standard/serialization/system-text-json-migrate-from-newtonsoft-how-to?pivots=dotnet-5-0#preserve-object-references-and-handle-loops

Alberto Passalacqua

@AlbertoPa

Thanks @roji. Where can I set the option thought? For regular controller serialization, it is done when adding controllers to the app, and I have the preserve option there. Can I pass the same option to STJ for EF?

Shay Rojansky

@roji

@AlbertoPa you're right that this isn't fully supported yet - see npgsql/efcore.pg#1107. That issue contains a workaround that will probably be sufficient for your case.

Elad

@Elad53820332_twitter

Thanks, I know it's out of support in MS. The problem is that I can't upgrade in the server since the client uses it... So I downgraded to NpgSQL version 2.2 I think the driver will be slower but I can't wait for my client team...

Thanks @roji

Alberto Passalacqua

@AlbertoPa

Thanks @roji I'll give it a try!

I am still not sure how it can fail, because I am reading the json from the DB (a jsonb) column, storing it into another field in another model after just setting values (no structure change to the json), and puff :laughing:

Yousif Touma

@yousiftouma

Hey there. We've updated from EFCore 2.6 -> 3.1 -> 5.0 recently (mid update to 3.1 we decided to go to 5.0 directly, so till running 2.6 in prod) and in the jump from 3.1 -> 5.0, I got this diff in my OnModelCreating (DB-first approach)

.HasAnnotation("ProductVersion", "2.2.6-servicing-10079");
.HasAnnotation("Relational:Collation", "English_Sweden.1252");

I tried google for info but didn't find anything helpful. Anyone that could fill me in on what this means? Anything I need to test somehow on the prod server?

Yousif Touma

@yousiftouma

sorry, the first dot is supposed to be a negative sign (line removed) and the second a positive sign (line added)

Ihar Peshka

@iharpeshka

Hello everybody

I have issue with npgsql on ubuntu server. My application is running on docker. When I select record with an enum I get an error. Can't cast database type public.language to Int32. On my PC and other servers this is OK

akshayjoyinfo

@akshayjoyinfo

Hi All, its my first time here in the Group,
I have question about replicating data into two different tables

Consider this example

I am getting some BookingData from one of the api as json => I am saving the data in the Table1 as
Id - Pk Bigint
UniqueID- unique string value
data - jsonb
these data I need to sent to other parties I can simply dump json and sent to others
Also once step completed I need these data need to be filtered from my UI application, which meanas i need to use normalized tables
Table2, Table3, Table4 with Pk-FK tables

question is it okay to write the data into diffrent places in tow different formats, so that my read or UI/API can be much easy to have complete filters
or
do I need to live with single table normalize all data, when you send again group together and sent to othres..

tell me whihc is option is good?
for me writing two places, so that UI/others can rely on the data..

Shay Rojansky

@roji

@iharpeshka check that you're using the same Npgsql version on both machines - otherwise you're going to have to submit a code sample

@akshayjoyinfo this channel is for asking questions about the Npgsql driver (and the EF Core provider), rather than to discuss what your database schema looks like... I'd recommend posting a question on stackoverflow

akshayjoyinfo

@akshayjoyinfo

yeah sure will do that.

mm3141

@mm3141

Hi, is there some expression tree mapping for EFCore with npgsql mapping to array concatenation ( || operator)?

Stanislav

@sflusov

Hello guys,
Could you look why some links on you site have been stop worked on the, i.e.

William Denton

@williamdenton

Hi @roji , we have run into this bug in production npgsql/npgsql#3469
can you advise when 5.0.3 will be released to nuget? We are debating wether to revert our upgrade to ef5/npqsql5 or wait for the patch. We can realistically wait no more than 24 hours before we have to revert so we can continue shipping features on our service

William Denton

@williamdenton

hm, that sentence doesn't quite read right... we have deployed an old version of our microservice from before the upgrade to restore service. the revert is referring to the Pull Request we would need to revert internally to undo the net5 updates. Our preference would be to roll forward with the new drivers than undo it all and try agin later

Yoh Deadfall

@YohDeadfall

I think nothing block us from release, but I would like to see npgsql/npgsql#3402 merged first. @roji ?

William Denton

@williamdenton

thanks @YohDeadfall we will revert our upgrade and try again soon.

Where communities thrive

People

Repo info

Activity