Mercurial > lada > lada-server
changeset 1314:1a3e86f4d768
Fix broken array and improve readability of function definition.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 17 Mar 2017 13:00:31 +0100 |
| parents | b5ab25b7ac2c |
| children | 84bb7e2aecb1 |
| files | db_schema/audit.sql |
| diffstat | 1 files changed, 9 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/db_schema/audit.sql Fri Mar 17 12:52:23 2017 +0100 +++ b/db_schema/audit.sql Fri Mar 17 13:00:31 2017 +0100 @@ -121,7 +121,13 @@ SECURITY DEFINER SET search_path = land, public; -CREATE OR REPLACE FUNCTION audit_table(target_table regclass, audit_rows boolean, audit_query_text boolean, ignored_cols text[]) RETURNS void AS $body$ +CREATE OR REPLACE FUNCTION audit_table( + target_table regclass, + audit_rows boolean, + audit_query_text boolean, + ignored_cols text[] +) RETURNS void AS +$body$ DECLARE stm_targets text = 'INSERT OR UPDATE OR DELETE OR TRUNCATE'; _q_txt text; @@ -215,7 +221,8 @@ SELECT audit_table('probe', true, false, '{id, tree_modified, letzte_aenderung}'::text[]); -SELECT audit_table('messung', true, false, '{id,, tree_modified, letzte_aenderung, status}'::text[]); +SELECT audit_table('messung', true, false, + '{id, tree_modified, letzte_aenderung, status}'::text[]); SELECT audit_table('messwert', true, false, '{id, tree_modified, letzte_aenderung}'::text[]); SELECT audit_table('kommentar_p', true, false, '{id, tree_modified, letzte_aenderung}'::text[]); SELECT audit_table('kommentar_m', true, false, '{id, tree_modified, letzte_aenderung}'::text[]);