The following bug has been logged on the website:
Bug reference: 17078
Logged by: Ali Pinjari
Email address: aliakbar.pinjari@gmail.com
PostgreSQL version: 10.14
Operating system: AWS Postgres RDS
Description:
Hi Team,
Facing timeout issue in getting large amount data in Dot Net application
using cursors. We are using Npgsql dll of 4.0.10 version.
More details:- We are using a postgress function which returns three cursors
i.e. three table data. When getting data using cursor from the application
taking more time and sometimes getting timeout or connection issues. Where
as same executed in the DB, getting results in seconds.
Exact error:- A connection attempt failed because the connected party did
not properly respond after a period of time, or established connection
failed because connected host has failed to respond at
System.Net.Sockets.Socket.Receive
Do we have any alternative in returning more than one table data from a
function without using ref cursor?