PGProcedure

[euanlau]

Do we have a PGFunction equivalent for procedure statement?

Right now we could do
PGFunction.from_sql('create function...') or PGFunction(..constructor params)

Is there a PGProcedure class that we can use to generate a create procedure statement ?

https://www.postgresql.org/docs/11/sql-createprocedure.html

[olirice]

There is no support for procedures currently as (afaik) the functionality is a subset of functions. Is there something specific you need that can't work as a function?

[euanlau]

More for compatibility purpose. Having some existing statements that are in the form of procedure. It would be nice if one could use something like PGProcedure instead of updating existing codebase/db.

[olirice]

Got it

No, there is not support for procedures and it isn't currently on the roadmap

But if anything is missing from functions that prevents porting procedures to them I'd be interested in supporting it

[diegoful-fr]

But if anything is missing from functions that prevents porting procedures to them I'd be interested in supporting it

Procedures can do transaction management, while functions cannot. This allows for a whole set of use cases that are supported by procedures, but not by functions.