We are having an issue with executing functions in a multi schema postgres database using the Entity Framework.
Problem Domain
- function_exec is Imported from Shechma_A
- The function calls another function function_test in Schema_B during the execution
- An error is generated indicating the function_test could not be found.
I have tried adding all of the schemas in the Initial Schema property of the connection string but it has not made any difference. I would think there would be a way to do this.
NOTE: I am able to run the function_exec from within PGAdmin using the same credentials being used for the EF connection, so there are no permission problems.