passing extra parameters to insert/update postgresql

Question

PostgreSQL

Good time!
Such a task is worth it - there is a devices table, there is a device_log table. When devices are changed by triggers, an event is written to the log.
Now the task becomes more complicated - we hang editing the values ​​​​partially on the web-muzzle with separation of rights. At the same time, you need to know who performed this or that action. I don’t see the point in writing new functions - triggers in the database do their job perfectly. I would like to pass the $_SESSION['user_id'] parameter to insert/update queries. But how?

Answer 1

www.stackoverflow.com/a/13172964

Answer 2

What is it that bothers you? :)
pg_query($conn, "INSERT INTO device_log (user_id) VALUES ({$_SESSION['user_id']})");

Answer 3

missed

Answer 4

You can add a field to devices, like modified_by , that will store the last user who changed the record. Then the user will also be available in the trigger, and it will be possible to add him to the log.

Answer 5

You can add a calculated field to the table, which is always NULL, and specify a value for it when inserting records. For INSTEAD OF triggers, in theory, it should work (at least it works in MsSQL).