79494697

Date: 2025-03-08 16:44:14
Score: 3
Natty:
Report link

A couple of recommendations:

1. save only old changed values

2. use FOR EACH STATEMENT trigger (not FOR ROW)

3. capture the context: transaction, statement etc

--

There is my solution - https://github.com/PGSuite/PGHist,

you can generate a trigger and view/copy it

Reasons:
  • Contains signature (1):
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: PGSuite