3 ms·

I find it frustrating that stored procedures can't start and stop transactions. Without that ability, you can't really move application logic into the database.

I find it frustrating that stored procedures can't start and stop transactions. Without that ability, you can't really move application logic into the database. [edit: Doh, I'm wrong. Sorry. I'll leave the comment here.]

petereisentraut 6y ago
Sure they can. See example here: https://www.postgresql.org/docs/current/plpgsql-transactions.html https://www.postgresql.org/docs/current/plpgsql-transactions...
- deleted 6y ago
  [deleted]
Tostino 6y ago
You're a release behind with that as the other person who replied said. I've made use of them for helping manage ETL flows between my DW and OLTP database.
abrookewood 6y ago
Slightly off-topic, but how comfortable are people with using stored procedures nowadays? I had developers in the past swear by them and I know that the early version of CloudFlare was almost entirely built using stored procs. On the other hand, I've had others who view them as something to be avoided at all costs.