Re: Schema diff tools excludes the SET directive from the function header

Конечно!
https://github.com/pgadmin-org/pgadmin4/issues/6651
--
С уважением, Дмитрий!

чт, 3 авг. 2023 г. в 12:17, Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>:

> Hi
>
> Can you please log the issue on GitHub
> <https://github.com/pgadmin-org/pgadmin4/issues/new>?
>
>
> On Thu, Aug 3, 2023 at 6:18 AM Дмитрий Иванов <firstdismay(at)gmail(dot)com>
> wrote:
>
>> Hi
>> Schema diff utilities exclude the SET directive from the function header
>> in compare mode.
>> Reproducing the problem:
>> 1. Create a copy of the database with the function containing the SET
>> directive
>> 2. Modify the function and perform the comparison.
>> In the resulting script, I am missing the SET directive in the function:
>>
>> CREATE OR REPLACE FUNCTION bpd.class_del(
>> iid bigint)
>> RETURNS void
>> LANGUAGE 'plpgsql'
>> COST 100
>> VOLATILE SECURITY DEFINER PARALLEL UNSAFE
>> <--SET search_path=bpd, err-->
>> AS $BODY$
>> --
>> Regards, Dmitry!
>>
>