[Fixed] Cannot retrieve list of Postgres stored procedures with /service/_proc/

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.

1 Like