Re: Changing a schema's name with function1 calling function2

2023-12-30 Thread Adrian Klaver
On 12/30/23 08:01, Wilma Wantren wrote: Thank you all, and especially you, Adrian, for your answers. However, I find the last suggestion too complicated. In Peter's words I had suggested a "magic variable" __function_schema__ which can be set as the search_path of a function to select - when ex

Re: Need help

2023-12-30 Thread Adrian Klaver
On 12/29/23 21:56, ankit.si...@nest-is2.com wrote: It's giving one more error please have a look. All that is telling you is that the underlying error you first reported "pg restore unsupported 1.15" caused one of the Zulip commands to fail. The issue still remains that you have a mismatch

Re: Re: Changing a schema's name with function1 calling function2

2023-12-30 Thread Wilma Wantren
Thank you all, and especially you, Adrian, for your answers. However, I find the last suggestion too complicated. In Peter's words I had suggested a "magic variable" __function_schema__ which can be set as the search_path of a function to select - when executing the function - the schema the fun