In relation to my other question "What’s the best way to audit log DELETEs?". What's the PostgreSQL equivalent of CONTEXT_INFO
?
I want to log deletes using a trigger, but since I'm not using the database user as my app's logical user, I cannot log the CURRENT_USER
from the trigger code as the user who deleted the record. But for INSERT
and UPDATE
it is possible to log the record changes from trigger since you can just add a user field in the record, say inserted_by
and last_updated_by
, and use these fields to log to audit table.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…