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

Поиск
Список
Период
Сортировка
От Akshay Joshi
Тема Re: Schema diff tools excludes the SET directive from the function header
Дата
Msg-id CANxoLDf_h_0nenjrsKWzVs9uhcqhzf4S_gOt+1+C3KM4tNv80g@mail.gmail.com
обсуждение исходный текст
Ответ на Schema diff tools excludes the SET directive from the function header  (Дмитрий Иванов <firstdismay@gmail.com>)
Ответы Re: Schema diff tools excludes the SET directive from the function header  (Дмитрий Иванов <firstdismay@gmail.com>)
Список pgadmin-support
Hi

Can you please log the issue on GitHub?


On Thu, Aug 3, 2023 at 6:18 AM Дмитрий Иванов <firstdismay@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!

В списке pgadmin-support по дате отправления:

Предыдущее
От: Aditya Toshniwal
Дата:
Сообщение: Re: Ошибка pgAdmin4 v7.5
Следующее
От: Дмитрий Иванов
Дата:
Сообщение: Re: Schema diff tools excludes the SET directive from the function header