a wrote: > I was request to write a trigger that perform the following function: > > 1, The trigger will be set to exam all statement that will result change of > datas > > 2, The trigger will exam three information other than the data updated or > inserted: > user name, password and reasons of change > > 3, It will record down, in some format, the time and content of the change. > > Therefore, I would need some way of passing parameters into the trigger > function. > Can anyone give me some instructions on how to do it or, if it is possible??
The only information you can pass to a trigger function are the old and new values of the table row being changed and the constants you can supply to the trigger function during CREATE TRIGGER. Everything else will have to be drawn from the current state of the database. One thing you can do is to define your own GUC (configuration parameter) and set that before you run the data modifying SQL statement. Then you can read that information in the trigger. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
