{"action":"closed","issue":{"url":"https://api.github.com/repos/uptimejp/sql_firewall/issues/11","labels_url":"https://api.github.com/repos/uptimejp/sql_firewall/issues/11/labels{/name}","comments_url":"https://api.github.com/repos/uptimejp/sql_firewall/issues/11/comments","events_url":"https://api.github.com/repos/uptimejp/sql_firewall/issues/11/events","html_url":"https://github.com/uptimejp/sql_firewall/issues/11","id":103977413,"number":11,"title":"sql_firewall and pgbench -i","user":{"login":"MasaoFujii","id":157553,"avatar_url":"https://avatars.githubusercontent.com/u/157553?v=3","gravatar_id":"","url":"https://api.github.com/users/MasaoFujii","html_url":"https://github.com/MasaoFujii","followers_url":"https://api.github.com/users/MasaoFujii/followers","following_url":"https://api.github.com/users/MasaoFujii/following{/other_user}","gists_url":"https://api.github.com/users/MasaoFujii/gists{/gist_id}","starred_url":"https://api.github.com/users/MasaoFujii/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MasaoFujii/subscriptions","organizations_url":"https://api.github.com/users/MasaoFujii/orgs","repos_url":"https://api.github.com/users/MasaoFujii/repos","events_url":"https://api.github.com/users/MasaoFujii/events{/privacy}","received_events_url":"https://api.github.com/users/MasaoFujii/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-08-31T03:08:21Z","updated_at":"2015-09-01T03:48:04Z","closed_at":"2015-09-01T03:48:04Z","body":"Hi,\r\n\r\nWhen I ran the following steps, I got unexpected warning messages.\r\nIs this a bug? Or am I missing something?\r\n\r\n  1. Set sql_firewall.firewall to learning\r\n  2. Run pgbench -i\r\n  3. Set sql_firewall.firewall to permissive\r\n  4. Run pgbench -i\r\n\r\nThe last call of pgbench -i caused the following warning messages.\r\n\r\n  WARNING: Prohibited SQL statement\r\n\r\nBTW, I performend the above steps by executing the following\r\nshell script.\r\n\r\n```\r\nbin/pg_ctl -D data stop -m f\r\nrm -rf data\r\n\r\nbin/initdb -D data --no-locale --encoding=UTF8\r\necho \"shared_preload_libraries = 'sql_firewall'\" >> data/postgresql.conf\r\necho \"sql_firewall.firewall = 'disabled'\" >> data/postgresql.conf\r\n\r\nbin/pg_ctl -D data start -w\r\nbin/psql <<EOF\r\nCREATE EXTENSION sql_firewall;\r\nALTER SYSTEM SET sql_firewall.firewall = 'learning';\r\nEOF\r\n\r\nbin/pg_ctl -D data restart -w\r\nbin/pgbench -i\r\n\r\nbin/psql <<EOF\r\nSELECT * FROM sql_firewall.sql_firewall_statements;\r\nALTER SYSTEM SET sql_firewall.firewall = 'permissive';\r\nEOF\r\n\r\nbin/pg_ctl -D data restart -w\r\nbin/pgbench -i\r\n```\r\n\r\nRegards,"}}