Schema diff tools excludes the SET directive from the function header

From: Дмитрий Иванов <firstdismay(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Schema diff tools excludes the SET directive from the function header
Date: 2023-08-03 00:48:14
Message-ID: CAPL5KHqaBU-sCNM0zkyQ08vbXY02Qqtw5xjBXZi8=ncHs-WA_A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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!

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message billy donald 2023-08-03 03:23:14 pgadmin 4 Not opening
Previous Message David G. Johnston 2023-08-02 16:50:41 Re: Assign User Defined DataType To Columns