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 Дмитрий Иванов <firstdis...@gmail.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! >
