You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Occasionally it's necessary to create a PROCEDURE instead of a FUNCTION. Specifically, PROCEDUREs invoked with CALL can do their own transaction management, while FUNCTIONs cannot.
It's possible to create, replace, and drop PROCEDUREs using the SQL editor, but they don't show up in the Functions view, which makes accessing and editing them very difficult.
To Reproduce
Use the SQL editor to create a PROCEDURE, for example:
CREATE OR REPLACE PROCEDURE public.myproc()
LANGUAGE plpgsql
AS $procedure$
declare
begin-- do something here
end;$procedure$
;
Open the Database / Functions view and select the specified schema (if necessary) to find it. It won't be there, and if search for it using the search box, it won't show up either.
Expected behavior
PROCEDUREs should be shown in the Functions view together with actual FUNCTIONs. There should be some symbol or similar that allows to distinguish which is which.
Alternatively, there could be a separate Database / Procedures view just for them.
Ideally it should also be possible to create them using the GUI. Either by adding to the "Add a new function" view a checkbox "Create as procedure" (or something similar). Or, if there is a new Database / Procedures view, by adding a "Add a new procedure" button there.
System information
All/latest.
The text was updated successfully, but these errors were encountered:
Bug report
Describe the bug
Occasionally it's necessary to create a PROCEDURE instead of a FUNCTION. Specifically, PROCEDUREs invoked with CALL can do their own transaction management, while FUNCTIONs cannot.
It's possible to create, replace, and drop PROCEDUREs using the SQL editor, but they don't show up in the Functions view, which makes accessing and editing them very difficult.
To Reproduce
Expected behavior
PROCEDUREs should be shown in the Functions view together with actual FUNCTIONs. There should be some symbol or similar that allows to distinguish which is which.
Alternatively, there could be a separate Database / Procedures view just for them.
Ideally it should also be possible to create them using the GUI. Either by adding to the "Add a new function" view a checkbox "Create as procedure" (or something similar). Or, if there is a new Database / Procedures view, by adding a "Add a new procedure" button there.
System information
All/latest.
The text was updated successfully, but these errors were encountered: