I’ve created a stored procedure in Postgres, which I can call through the DF API using /{service_name}/_proc/{procedure_name}. However, I can’t retrieve the list of stored procedures in the database using /{service_name}/_proc/.
I don’t need the functionality myself, but it seems like a possible bug. Is there a way of refreshing DF’s list of stored procedures that I’m missing?
Edit: I found a solution buried deep in another thread. You can force DF to refresh the procedure or function lists through the API by calling {service_name}/_proc?refresh=true . Seems like you could also restart apache, but it’s nice that there’s a zero-downtime approach as well.