Include procedures in pglift set-profile

pglift version

2.4.0

Summary

pglift set-profile doesn't give any permission on procedures.

As per the documentation, executing pglift set-profile commands works on tables, sequences, functions, and types.

read-only, which executes GRANT with the following options and objects:
   SELECT on tables and sequences
   EXECUTE on functions
   USAGE on types

Functions are processed, but procedures are not, because they are considered a different kind of object. I can't think of a reason for not including them though.

As a side node, in PostgreSQL, while a PROCEDURE and a FUNCTION are different objects, using keyword ROUTINE, both types can be referenced simultaneously.

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information