audit trigger: problem with schema

[3nids]

trafficstars

The quote_ident calls are useless and prevent the use of the function with schema defined regclass (i.e. schema.table). So, to make the trigger available on other schemas than public, I had to remove the quote_ident.

[ringerc]

It looks like you're talking about audit.sql. If so, the quote_ident calls are moderately useful (since table names can include SQL metachars) but it should instead really use format() and the %I specifier, since that's properly schema-aware. If I get the chance I'll patch this; otherwise it's pretty easy for you to convert by replacing string concatenation with format using %L and %I.

[3nids]

Hi, do you have by any chance some time to fix this? Thanks a lot, Denis