Revision 12251
Added by Aaron Marcuse-Kubitza almost 11 years ago
| util.sql | ||
|---|---|---|
| 1114 | 1114 |
LANGUAGE plpgsql STRICT |
| 1115 | 1115 |
AS $$ |
| 1116 | 1116 |
BEGIN |
| 1117 |
RAISE NOTICE '%', sql;
|
|
| 1118 |
EXECUTE sql;
|
|
| 1117 |
PERFORM util.debug_print_sql(sql);
|
|
| 1118 |
EXECUTE sql;
|
|
| 1119 | 1119 |
END; |
| 1120 | 1120 |
$$; |
| 1121 | 1121 |
|
| ... | ... | |
| 1128 | 1128 |
LANGUAGE plpgsql |
| 1129 | 1129 |
AS $$ |
| 1130 | 1130 |
BEGIN |
| 1131 |
RAISE NOTICE '%', sql;
|
|
| 1131 |
PERFORM util.debug_print_sql(sql);
|
|
| 1132 | 1132 |
RETURN QUERY EXECUTE sql; |
| 1133 | 1133 |
END; |
| 1134 | 1134 |
$$; |
| ... | ... | |
| 1151 | 1151 |
LANGUAGE plpgsql |
| 1152 | 1152 |
AS $$ |
| 1153 | 1153 |
BEGIN |
| 1154 |
RAISE NOTICE '%', sql;
|
|
| 1154 |
PERFORM util.debug_print_sql(sql);
|
|
| 1155 | 1155 |
RETURN QUERY EXECUTE sql; |
| 1156 | 1156 |
END; |
| 1157 | 1157 |
$$; |
| ... | ... | |
| 1176 | 1176 |
DECLARE |
| 1177 | 1177 |
ret_val ret_type_null%TYPE; |
| 1178 | 1178 |
BEGIN |
| 1179 |
RAISE NOTICE '%', sql;
|
|
| 1179 |
PERFORM util.debug_print_sql(sql);
|
|
| 1180 | 1180 |
EXECUTE sql INTO STRICT ret_val; |
| 1181 | 1181 |
RETURN ret_val; |
| 1182 | 1182 |
END; |
| ... | ... | |
| 2378 | 2378 |
), ' |
| 2379 | 2379 |
, '), ''); |
| 2380 | 2380 |
BEGIN |
| 2381 |
RAISE NOTICE '%', sql;
|
|
| 2381 |
PERFORM util.debug_print_sql(sql);
|
|
| 2382 | 2382 |
EXECUTE COALESCE(sql, ''); |
| 2383 | 2383 |
END; |
| 2384 | 2384 |
$_$; |
Also available in: Unified diff
schemas/util.sql: use new util.debug_print_sql() instead of `RAISE NOTICE` to improve readability of the debug output (which is used throughout the runscripts)