search

2ndQuadrant / audit-trigger

Simple, easily customised trigger-based auditing for PostgreSQL (Postgres). See also pgaudit.
Other
657 stars 241 forks source link

Fix to allow auditing tables in other schemas #20

Closed mikijov closed 5 years ago

mikijov commented 8 years ago

Removed quote_ident as regclass variables can safely be used to create dynamic sql. This enables target_table to reference tables in different schemas.

saward commented 5 years ago

Needed to use this fix to allow auditing of a 'user' table. Since this PR was created nearly 3 years ago, have you noticed any issues from this modification?

mikijov commented 5 years ago

The fix works well for me, although I am still using postgresql 9.x.

ringerc commented 5 years ago

Thanks. Better late than never.