After running learning mode, a SQL statement which include SQL function was captured in sql_firewall_statements. When enforcing mode is turned on for the postgresql server, running the same statement encounter Prohibited SQL statement error "CONTEXT: SQL function xxx during startup" .
The SQL function is something like this
"select description from pg_catalog.pg_description where objoid = $1 and classoid = 'pg_catalog.pgclass'::pg_catalog.regclass and objsubid = $2"
After running learning mode, a SQL statement which include SQL function was captured in sql_firewall_statements. When enforcing mode is turned on for the postgresql server, running the same statement encounter Prohibited SQL statement error "CONTEXT: SQL function xxx during startup" .
The SQL function is something like this "select description from pg_catalog.pg_description where objoid = $1 and classoid = 'pg_catalog.pgclass'::pg_catalog.regclass and objsubid = $2"