UI Dashboard: Database Functions: can't edit, arguments get wiped

[stuartcrobinson]

can't edit or display database function arguments from the UI, especially functions created from the UI

Steps to reproduce:

creating a function:

now trying to edit that same function:

can't see or edit arguments:

note: it displays arguments for functions defined in the project .sql file, but still wont let me edit them:

[GaryAustin1]

Postgres considers the parameter names and types as a fixed part of the function. If they change you have a new function and the old one still exists with the other parameters.

https://www.postgresql.org/docs/current/sql-createfunction.html#SQL-CREATEFUNCTION-DESCRIPTION

To replace the current definition of an existing function, use CREATE OR REPLACE FUNCTION. It is not possible to change the name or argument types of a function this way (if you tried, you would actually be creating a new, distinct function). Also, CREATE OR REPLACE FUNCTION will not let you change the return type of an existing function. To do that, you must drop and recreate the function. (When using OUT parameters, that means you cannot change the types of any OUT parameters except by dropping the function.)

So normally you have to delete the function and create a new one even in SQL.

[stuartcrobinson]

^^ interesting

coming back to add that then it wouldn't let me edit the function at all. that "Name of argument" is not editable