Attempt to create **pg_stat_kcache** extension forcibly switch **check_function_bodies** parameter to **false**.

[rus21]

Attempt to create pg_stat_kcache extension forcibly switch check_function_bodies parameter to false.

    CREATE EXTENSION IF NOT EXISTS pg_stat_statements WITH SCHEMA public;
    COMMENT ON EXTENSION pg_stat_statements IS 'track execution statistics of all SQL statements executed';
    SET check_function_bodies = false;
    show check_function_bodies; *--false

    CREATE EXTENSION IF NOT EXISTS pg_stat_kcache WITH SCHEMA public;
    COMMENT ON EXTENSION pg_stat_kcache IS 'Kernel cache statistics gathering';
    show check_function_bodies; *--true

[rjuju]

Hello,

Indeed the extension set this parameter to on while installing. Commit d7734fb should fix this issue.

Thanks for the report.

Regards.

[rus21]

Hello Julien!
It ought to tell what this microbug was found during the restore (pg_dump script) of database with your extension installed.
Best wishes from participant of your presentation at Pgconf.Russia.2015!
Regards.