How to check and change function volatility in Postgres?
I checked the documentation again, and the answer to my second question is, yes you can alter it using the alter function query.

alter function my_function() stable;


Also, I see that checking for function volatility has been asked and answered before.

https://stackoverflow.com/questions/54452415/how-to-check-whether-a-function-is-immutable