I have 2 schemas , schema1 and schema 2.
1. GRANT USAGE ON SCHEMA schema1 TO schema2;
I am trying to create a function in shema2, In that function I need to access some tables from schema1.
p
I am getting the following error when I compile the function
Search path set to schema2,schema1,public
Can you please help? Appreciate your time
Regards