BUG #16244: Ref cursor from PostgreSQL and entity Framework

Started by PG Bug reporting formabout 6 years ago2 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following bug has been logged on the website:

Bug reference: 16244
Logged by: Ravi Sah
Email address: rblucky3@gmail.com
PostgreSQL version: 11.6
Operating system: Windows 10
Description:

I have a Function in PostgreSQL that has return type 'refcursor'. i'm using
this Function in Entity Framework by using Add Function Import.ThenI am
getting error in Entity Framework 6.0 that

"System.NotSupportedExcepction"

i have used Npgsql,dbconnect provider for connection to postgresql.

.Kindly provide solution for this problem..

#2David G. Johnston
david.g.johnston@gmail.com
In reply to: PG Bug reporting form (#1)
Re: BUG #16244: Ref cursor from PostgreSQL and entity Framework

On Wednesday, February 5, 2020, PG Bug reporting form <
noreply@postgresql.org> wrote:

The following bug has been logged on the website:

Bug reference: 16244
Logged by: Ravi Sah
Email address: rblucky3@gmail.com
PostgreSQL version: 11.6
Operating system: Windows 10
Description:

I have a Function in PostgreSQL that has return type 'refcursor'. i'm using
this Function in Entity Framework by using Add Function Import.ThenI am
getting error in Entity Framework 6.0 that

"System.NotSupportedExcepction"

i have used Npgsql,dbconnect provider for connection to postgresql.

.Kindly provide solution for this problem..

Rewrite the function to not use a refcursor which doesn’t seem to be a
supported element in your framework. Or, don’t use the framework. Either
way this doesn’t seem to meet the criteria for a bug report. Posts like
this should be direct to the -general list.

David J.