PostgreSQL 11 - Procedure support

Question

• PostgreSql Version : 11 Beta 4
• Npgsql Version : v4.0.3

I want to test Store Prodecure of PostgreSql, but I get the error.

"42809: get_customer_list() is a procedure"

My CommandType

CommandType.StoredProcedure

Does Npgsql support PostgreSql 11 Store Prodecure ?

Answer 1

Please see this answer in the Npgsql FAQ.

Long story short, you can call stored procedures but not with CommandType.StoredProcedure. Simply make a regular command with the text CALL my_stored_procedure().