Updating stored procedures fails with a syntax error, even with valid SQL code.

[rbrooklyn]

Please note that security bugs or issues should be reported to security@pgadmin.org.

Describe the bug

Trying to update a stored procedure, PGAdmin is giving an error, however, the code is perfectly valid.

When edited manually using a query, it works fine.

To Reproduce

Steps to reproduce the behavior:

1. Right click a stored procedure.
2. Make a change
3. Try to save

Expected behavior

Stored procedure should be updated.

It seems the SQL being created is incomplete. The SQL generated by right clicking and asking to edit the procedure is this:

But when I ask for a create script on the same object, it looks like this:

I presume the "AS $BODY$" line is required.

Error message

syntax error is shown. The exact error varies based on the script being edited.

Screenshots

Desktop (please complete the following information):

• OS: Windows 11
• pgAdmin version: 9.15
• Mode: Desktop
• Package type: Windows .exe file