Determining Function Signatures with Postgres

I had duplicate Postgres base signatures, and I needed to diagnose the reasons why it was failing to update. The following are helpful for diagnosing functions:

References

StackOverflow DROP FUNCTION without knowing the number/type of parameters?

StackOverflow: pg_proc