Error while calling proc with table type from Application - Mailing list pgsql-performance

From aditya desai
Subject Error while calling proc with table type from Application
Date
Msg-id CAN0SRDFX79ZRcoY4SGKZH1yO3HcP4z8rjH9neOB1UCLcTXtdUA@mail.gmail.com
Whole thread Raw
Responses Re: Error while calling proc with table type from Application (npgsql)
List pgsql-performance
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)

 

Below is the error while executing proc -

“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.”


Regards,

Aditya.

pgsql-performance by date:

Previous
From: Jean-Christophe Boggio
Date:
Subject: Re: Order of execution
Next
From: Justin Pryzby
Date:
Subject: Re: Error while calling proc with table type from Application (npgsql)