Ivan Vakhrushev

Results 20 comments of Ivan Vakhrushev

Examples ```sql create or replace function add(a integer, b integer) returns integer language sql immutable returns null on null input return a + b; select * from add(1,2); ``` ```sql...

Dropped functions do not remain in metadata. `drop function if exists add(a integer, b integer);`

``` select n.nspname || '.' || p.proname as function_name, pg_get_function_identity_arguments(p.oid) as function_signature from pg_catalog.pg_namespace n join pg_catalog.pg_proc p on p.pronamespace = n.oid where (obj_description(p.oid) is null or length(trim(obj_description(p.oid))) = 0)...

Also take a look at https://habr.com/ru/articles/803841/

Parent of 1. https://github.com/mfvanek/pg-index-health-sql/issues/43 2. https://github.com/mfvanek/pg-index-health/issues/387 3. https://github.com/mfvanek/pg-index-health/issues/388 4. https://github.com/mfvanek/pg-index-health/issues/389 5. https://github.com/mfvanek/pg-index-health/issues/390 6. https://github.com/mfvanek/pg-index-health/issues/391

For example see - https://github.com/micrometer-metrics/micrometer/blob/main/micrometer-core/src/main/java/io/micrometer/core/instrument/binder/tomcat/TomcatMetrics.java - https://github.com/spring-projects/spring-boot/blob/main/spring-boot-project/spring-boot-actuator/src/main/java/org/springframework/boot/actuate/metrics/web/tomcat/TomcatMetricsBinder.java - https://github.com/spring-projects/spring-boot/blob/main/spring-boot-project/spring-boot-actuator-autoconfigure/src/main/java/org/springframework/boot/actuate/autoconfigure/metrics/web/tomcat/TomcatMetricsAutoConfiguration.java The most important thing here is that metrics can't be binded during bean creation. It leads to circular dependency. Should use...