pq: stack depth limit exceeded

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rushisocha
    New Member
    • Nov 2019
    • 2

    pq: stack depth limit exceeded

    I am getting below error while running postgres exporter.

    Error running query on database "localhost:5432 ": pg_stat_stateme nts pq: stack depth limit exceeded source="postgre s_exporter.go:1 286"


    This is what i did in database

    CREATE EXTENSION pg_stat_stateme nts;

    CREATE OR REPLACE FUNCTION get_pg_stat_sta tements() RETURNS SETOF pg_stat_stateme nts AS
    $$ SELECT * FROM pg_stat_stateme nts; $$
    LANGUAGE sql
    VOLATILE
    SECURITY DEFINER;

    CREATE OR REPLACE VIEW postgres_export er.pg_stat_stat ements
    AS
    SELECT * from get_pg_stat_sta tements();

    GRANT SELECT ON postgres_export er.pg_stat_stat ements TO postgres_export er;
Working...