Comment by const_cast
2 days ago
I think instead of performing an INSERT you call a stored proc that does the insert and some extra stuff.
2 days ago
I think instead of performing an INSERT you call a stored proc that does the insert and some extra stuff.
Yes, we already have all of our business logic in postgres functions(create_order, create_partial_payment etc).
Doing the extra work in stored procedures is noticeably faster than relying on triggers.