You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
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.
Activity
ringerc commentedon Mar 7, 2013
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 useformat()and the%Ispecifier, 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 withformatusing%Land%I.3nids commentedon Apr 11, 2013
Hi, do you have by any chance some time to fix this?
Thanks a lot,
Denis