From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
---|---|
To: | aditya desai <admad123(at)gmail(dot)com> |
Cc: | pgsql-performance(at)lists(dot)postgresql(dot)org |
Subject: | Re: Error while calling proc with table type from Application (npgsql) |
Date: | 2021-04-29 13:02:36 |
Message-ID: | 20210429130236.GI27406@telsasoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Thu, Apr 29, 2021 at 02:52:23PM +0530, aditya desai wrote:
> Hi,
> One of the procs which accept tabletype as parameter gives below error
> while being called from Application. Could not find a concrete solution for
> this. Can someone help?
>
> call PROCEDURE ABC (p_optiontable optiontype)
What is PROCEDURE ABC ? If you created it, send its definition with your problem report.
> Below is the error while executing proc -
How are you executing it? This seems like an error from npgsl, not postgres.
It may be a client-side error, and it may be that the query isn't even being
sent to the server at that point.
> “the clr type system.data.datatable isn't natively supported by npgsql or
> your postgresql. to use it with a postgresql composite you need to specify
> datatypename or to map it, please refer to the documentation.”
Did you do this ?
https://www.npgsql.org/doc/types/enums_and_composites.html
--
Justin
From | Date | Subject | |
---|---|---|---|
Next Message | Edson Richter | 2021-04-29 15:01:29 | Log number of tuples returned |
Previous Message | aditya desai | 2021-04-29 09:22:23 | Error while calling proc with table type from Application |