I set up the connection and then command components at design time. When I set the procedure name to public.GetCopies and try to execute I get the error message "function public.getcopies() does not exist" (notice the case change). It does not matter if I specify the name as "public"."GetCopies" either.
If I however rename the procedure at the db to "getcopies" (all lower case) - then "public"."getcopies" works.
It is a very annoying bug - I do not want - I cannot in fact - rename all procedures/functions to lowercase.
I use 2.40.14. It was the same under 2.40.13. I am not able to test under 2.50.15 due to the licence bug.
Regards,
Hubert
"Function xxx does not exist"
Function xxx does not exist
We have fixed the problem. The fix will be available in the next build of PostgreSQLDirect .NET. Watch for announcements in the forum.