Question 38314 in Ubuntu Question posted in
The official Ubuntu documentation can be found here.

Cannot add more arguments to procedure in pgAdmin 4, Ubuntu 22.10. How can I fix the add option or add arguments programatically?

I am using pgAdmin 4 to create and update stored procedures. I want to add more arguments to one existing procedure but the add option is not available:
Without add option when modifying procedure

What I expect to see is the "+" option, as it appears when I create a procedure With add option when creating procedure

The only answer I know is to re-create the procedure, but I think there must be a better answer.

How can I make the "+" option appear?
If it is not possible, how can I add arguments to the procedure using queries?

More details: using the version 6.17 of pgAdmin 4.

Any advice is welcome, thank you!

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    The "Properties" option seems not to be a comfortable way to work, found this fast way to add arguments using pgAdmin4:

    • On the menu, right-click on procedure.
    • Instead of using "properties" option, use Scripts > Create script.
    • On resulting script, uncomment "drop" line, then add arguments. Also do all changes required and run script.

  2. 0

    The only option is to drop the function and create a new one, which is not an expensive operation. CREATE OR REPLACE FUNCTION is only possible if the signature doesn’t change.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search