Обсуждение: Schema diff tools excludes the SET directive from the function header
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:
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$
iid bigint)
RETURNS void
LANGUAGE 'plpgsql'
COST 100
VOLATILE SECURITY DEFINER PARALLEL UNSAFE
<--SET search_path=bpd, err-->
AS $BODY$
--
Regards, Dmitry!Hi
Can you please log the issue on GitHub?
On Thu, Aug 3, 2023 at 6:18 AM Дмитрий Иванов <firstdismay@gmail.com> wrote:
HiSchema 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!
Конечно!
чт, 3 авг. 2023 г. в 12:17, Akshay Joshi <akshay.joshi@enterprisedb.com>:
HiCan you please log the issue on GitHub?On Thu, Aug 3, 2023 at 6:18 AM Дмитрий Иванов <firstdismay@gmail.com> wrote:HiSchema 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!