News for hackers. Stuff that matters.
Re:Postgres Auditing in 150 lines of SQL by giraffe_lady on Wednesday March 09, 2022 @08:53PM (#30622387)
Yep you can, though a lot of systems that should know better also assume they don't have side effects. For example postgrest GETs happen in readonly transactions which would cause a problem if you wanted to use a system like this to keep an audit logs of hits to a certain endpoint or whatever.

I think you can use a standalone VALUES statement to avoid side effects? Those aren't well supported even though it's part of the SQL spec, but postgres does have them.

There are no comments on this comment yet.