| From: | Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com> |
|---|---|
| To: | Дмитрий Иванов <firstdismay(at)gmail(dot)com> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: Schema diff tools excludes the SET directive from the function header |
| Date: | 2023-08-03 07:16:48 |
| Message-ID: | CANxoLDf_h_0nenjrsKWzVs9uhcqhzf4S_gOt+1+C3KM4tNv80g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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!
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Дмитрий Иванов | 2023-08-03 08:02:54 | Re: Schema diff tools excludes the SET directive from the function header |
| Previous Message | Aditya Toshniwal | 2023-08-03 03:40:13 | Re: Ошибка pgAdmin4 v7.5 |