You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{"payload":{"commit":{"oid":"6e37312a2a595b7f75e1190b2d15e88d54b366a7","url":"/postgres/postgres/commit/6e37312a2a595b7f75e1190b2d15e88d54b366a7","authoredDate":"2022-07-31T16:58:20.000-04:00","committedDate":"2022-07-31T16:58:41.000-04:00","shortMessage":null,"shortMessageMarkdown":"\u003cdiv\u003eRemove test_oat_hooks.c's nodetag_to_string().\u003c/div\u003e","shortMessageMarkdownLink":null,"bodyMessageHtml":"In the short time this function has existed, it's already proven to be\na nontrivial maintenance burden, since it has to be updated whenever a\nnode tag is added or removed. Although in principle we could now\nautomate that, I see little justification for having such functionality\nhere at all. The function is only being applied to utility statements,\nfor which we already have infrastructure for obtaining string names.\nMoreover, that infrastructure produces already-familiar-to-users names,\nunlike nodetag_to_string().\n\nSo, remove this function and use the existing infrastructure instead.\nThat saves over a thousand lines of largely-unreachable code.\n\nBack-patch to v15 where this code came in. Although it seems unlikely\nthat v15's nodetag list will change anymore, we might as well keep the\ntwo branches looking and acting alike; otherwise back-patching any\ntest-results changes in this area will be painful.\n\nDiscussion: \u003ca href=\"https://postgr.es/m/843818.1659218928@sss.pgh.pa.us\" rel=\"nofollow\"\u003ehttps://postgr.es/m/843818.1659218928@sss.pgh.pa.us\u003c/a\u003e","authors":[{"login":"tglsfdc","displayName":"Tom Lane","avatarUrl":"https://avatars.githubusercontent.com/u/8755309?v=4","path":"/tglsfdc","isGitHub":false}],"committerAttribution":false,"committer":{"login":"tglsfdc","displayName":"Tom Lane","avatarUrl":"https://avatars.githubusercontent.com/u/8755309?v=4","path":"/tglsfdc","isGitHub":false},"parents":["9c9fc20e6fdf34d480b55bd517487b0affbf18e0"],"globalRelayId":"C_kwDOAA4m0toAKDZlMzczMTJhMmE1OTViN2Y3NWUxMTkwYjJkMTVlODhkNTRiMzY2YTc","sha1":"9c9fc20e6fdf34d480b55bd517487b0affbf18e0","sha2":"6e37312a2a595b7f75e1190b2d15e88d54b366a7"},"currentUser":null,"repo":{"id":927442,"defaultBranch":"master","name":"postgres","ownerLogin":"postgres","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2010-09-21T11:35:45.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/177543?v=4","public":true,"private":false,"isOrgOwned":true},"diffEntryData":[{"diffLines":[{"stylingDirective":null,"type":"HUNK","blobLineNumber":10,"text":"@@ -11,26 +11,26 @@ LOAD 'test_oat_hooks';","html":"@@ -11,26 +11,26 @@ LOAD \u0026#39;test_oat_hooks\u0026#39;;","displayNoNewLineWarning":false,"position":0,"left":10,"right":10},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":11,"text":" SET test_oat_hooks.audit = true;","html":" SET test_oat_hooks.audit = true;","displayNoNewLineWarning":false,"position":1,"left":11,"right":11},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":12,"text":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [test_oat_hooks.audit]","html":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [test_oat_hooks.audit]","displayNoNewLineWarning":false,"position":2,"left":12,"right":12},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":13,"text":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [test_oat_hooks.audit]","html":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [test_oat_hooks.audit]","displayNoNewLineWarning":false,"position":3,"left":13,"right":13},{"stylingDirective":null,"type":"DELETION","blobLineNumber":14,"text":"-NOTICE: in process utility: superuser finished set","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":4,"left":14,"right":13},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":14,"text":"+NOTICE: in process utility: superuser finished SET","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":5,"left":14,"right":14},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":15,"text":" -- Creating privileges on an existent custom GUC should create precisely the","html":" -- Creating privileges on an existent custom GUC should create precisely the","displayNoNewLineWarning":false,"position":6,"left":15,"right":15},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":16,"text":" -- right privileges, not overly conservative ones.","html":" -- right privileges, not overly conservative ones.","displayNoNewLineWarning":false,"position":7,"left":16,"right":16},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":17,"text":" GRANT SET ON PARAMETER test_oat_hooks.user_var2 TO regress_role_joe;","html":" GRANT SET ON PARAMETER test_oat_hooks.user_var2 TO regress_role_joe;","displayNoNewLineWarning":false,"position":8,"left":17,"right":17},{"stylingDirective":null,"type":"DELETION","blobLineNumber":18,"text":"-NOTICE: in process utility: superuser attempting GrantStmt","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":9,"left":18,"right":17},{"stylingDirective":null,"type":"DELETION","blobLineNumber":19,"text":"-NOTICE: in process utility: superuser finished GrantStmt","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":10,"left":19,"right":17},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":18,"text":"+NOTICE: in process utility: superuser attempting GRANT","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eGRANT\u003c/span\u003e","displayNoNewLineWarning":false,"position":11,"left":19,"right":18},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":19,"text":"+NOTICE: in process utility: superuser finished GRANT","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eGRANT\u003c/span\u003e","displayNoNewLineWarning":false,"position":12,"left":19,"right":19},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":20,"text":" GRANT SET ON PARAMETER test_oat_hooks.super_var2 TO regress_role_joe;","html":" GRANT SET ON PARAMETER test_oat_hooks.super_var2 TO regress_role_joe;","displayNoNewLineWarning":false,"position":13,"left":20,"right":20},{"stylingDirective":null,"type":"DELETION","blobLineNumber":21,"text":"-NOTICE: in process utility: superuser attempting GrantStmt","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":14,"left":21,"right":20},{"stylingDirective":null,"type":"DELETION","blobLineNumber":22,"text":"-NOTICE: in process utility: superuser finished GrantStmt","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":15,"left":22,"right":20},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":21,"text":"+NOTICE: in process utility: superuser attempting GRANT","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eGRANT\u003c/span\u003e","displayNoNewLineWarning":false,"position":16,"left":22,"right":21},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":22,"text":"+NOTICE: in process utility: superuser finished GRANT","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eGRANT\u003c/span\u003e","displayNoNewLineWarning":false,"position":17,"left":22,"right":22},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":23,"text":" -- Granting multiple privileges on a parameter should be reported correctly to","html":" -- Granting multiple privileges on a parameter should be reported correctly to","displayNoNewLineWarning":false,"position":18,"left":23,"right":23},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":24,"text":" -- the OAT hook, but beware that WITH GRANT OPTION is not represented.","html":" -- the OAT hook, but beware that WITH GRANT OPTION is not represented.","displayNoNewLineWarning":false,"position":19,"left":24,"right":24},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":25,"text":" GRANT SET, ALTER SYSTEM ON PARAMETER none.such TO regress_role_joe;","html":" GRANT SET, ALTER SYSTEM ON PARAMETER none.such TO regress_role_joe;","displayNoNewLineWarning":false,"position":20,"left":25,"right":25},{"stylingDirective":null,"type":"DELETION","blobLineNumber":26,"text":"-NOTICE: in process utility: superuser attempting GrantStmt","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":21,"left":26,"right":25},{"stylingDirective":null,"type":"DELETION","blobLineNumber":27,"text":"-NOTICE: in process utility: superuser finished GrantStmt","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":22,"left":27,"right":25},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":26,"text":"+NOTICE: in process utility: superuser attempting GRANT","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eGRANT\u003c/span\u003e","displayNoNewLineWarning":false,"position":23,"left":27,"right":26},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":27,"text":"+NOTICE: in process utility: superuser finished GRANT","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eGRANT\u003c/span\u003e","displayNoNewLineWarning":false,"position":24,"left":27,"right":27},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":28,"text":" GRANT SET, ALTER SYSTEM ON PARAMETER another.bogus TO regress_role_joe WITH GRANT OPTION;","html":" GRANT SET, ALTER SYSTEM ON PARAMETER another.bogus TO regress_role_joe WITH GRANT OPTION;","displayNoNewLineWarning":false,"position":25,"left":28,"right":28},{"stylingDirective":null,"type":"DELETION","blobLineNumber":29,"text":"-NOTICE: in process utility: superuser attempting GrantStmt","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":26,"left":29,"right":28},{"stylingDirective":null,"type":"DELETION","blobLineNumber":30,"text":"-NOTICE: in process utility: superuser finished GrantStmt","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":27,"left":30,"right":28},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":29,"text":"+NOTICE: in process utility: superuser attempting GRANT","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eGRANT\u003c/span\u003e","displayNoNewLineWarning":false,"position":28,"left":30,"right":29},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":30,"text":"+NOTICE: in process utility: superuser finished GRANT","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eGRANT\u003c/span\u003e","displayNoNewLineWarning":false,"position":29,"left":30,"right":30},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":31,"text":" -- Check when the hooks fire relative to dependency based abort of a drop","html":" -- Check when the hooks fire relative to dependency based abort of a drop","displayNoNewLineWarning":false,"position":30,"left":31,"right":31},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":32,"text":" DROP ROLE regress_role_joe;","html":" DROP ROLE regress_role_joe;","displayNoNewLineWarning":false,"position":31,"left":32,"right":32},{"stylingDirective":null,"type":"DELETION","blobLineNumber":33,"text":"-NOTICE: in process utility: superuser attempting DropRoleStmt","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eDropRoleStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":32,"left":33,"right":32},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":33,"text":"+NOTICE: in process utility: superuser attempting DROP ROLE","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eDROP ROLE\u003c/span\u003e","displayNoNewLineWarning":false,"position":33,"left":33,"right":33},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":34,"text":" NOTICE: in object access: superuser attempting drop (subId=0x0) []","html":" NOTICE: in object access: superuser attempting drop (subId=0x0) []","displayNoNewLineWarning":false,"position":34,"left":34,"right":34},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":35,"text":" NOTICE: in object access: superuser finished drop (subId=0x0) []","html":" NOTICE: in object access: superuser finished drop (subId=0x0) []","displayNoNewLineWarning":false,"position":35,"left":35,"right":35},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":36,"text":" ERROR: role \"regress_role_joe\" cannot be dropped because some objects depend on it","html":" ERROR: role \u0026quot;regress_role_joe\u0026quot; cannot be dropped because some objects depend on it","displayNoNewLineWarning":false,"position":36,"left":36,"right":36},{"stylingDirective":null,"type":"HUNK","blobLineNumber":41,"text":"@@ -42,30 +42,30 @@ privileges for parameter none.such","html":"@@ -42,30 +42,30 @@ privileges for parameter none.such","displayNoNewLineWarning":false,"position":37,"left":41,"right":41},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":42,"text":" privileges for parameter another.bogus","html":" privileges for parameter another.bogus","displayNoNewLineWarning":false,"position":38,"left":42,"right":42},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":43,"text":" -- Check the behavior of the hooks relative to do-nothing grants and revokes","html":" -- Check the behavior of the hooks relative to do-nothing grants and revokes","displayNoNewLineWarning":false,"position":39,"left":43,"right":43},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":44,"text":" GRANT SET ON PARAMETER maintenance_work_mem TO PUBLIC;","html":" GRANT SET ON PARAMETER maintenance_work_mem TO PUBLIC;","displayNoNewLineWarning":false,"position":40,"left":44,"right":44},{"stylingDirective":null,"type":"DELETION","blobLineNumber":45,"text":"-NOTICE: in process utility: superuser attempting GrantStmt","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":41,"left":45,"right":44},{"stylingDirective":null,"type":"DELETION","blobLineNumber":46,"text":"-NOTICE: in process utility: superuser finished GrantStmt","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":42,"left":46,"right":44},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":45,"text":"+NOTICE: in process utility: superuser attempting GRANT","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eGRANT\u003c/span\u003e","displayNoNewLineWarning":false,"position":43,"left":46,"right":45},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":46,"text":"+NOTICE: in process utility: superuser finished GRANT","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eGRANT\u003c/span\u003e","displayNoNewLineWarning":false,"position":44,"left":46,"right":46},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":47,"text":" REVOKE SET ON PARAMETER maintenance_work_mem FROM PUBLIC;","html":" REVOKE SET ON PARAMETER maintenance_work_mem FROM PUBLIC;","displayNoNewLineWarning":false,"position":45,"left":47,"right":47},{"stylingDirective":null,"type":"DELETION","blobLineNumber":48,"text":"-NOTICE: in process utility: superuser attempting GrantStmt","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":46,"left":48,"right":47},{"stylingDirective":null,"type":"DELETION","blobLineNumber":49,"text":"-NOTICE: in process utility: superuser finished GrantStmt","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":47,"left":49,"right":47},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":48,"text":"+NOTICE: in process utility: superuser attempting REVOKE","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eREVOKE\u003c/span\u003e","displayNoNewLineWarning":false,"position":48,"left":49,"right":48},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":49,"text":"+NOTICE: in process utility: superuser finished REVOKE","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eREVOKE\u003c/span\u003e","displayNoNewLineWarning":false,"position":49,"left":49,"right":49},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":50,"text":" REVOKE ALTER SYSTEM ON PARAMETER maintenance_work_mem FROM PUBLIC;","html":" REVOKE ALTER SYSTEM ON PARAMETER maintenance_work_mem FROM PUBLIC;","displayNoNewLineWarning":false,"position":50,"left":50,"right":50},{"stylingDirective":null,"type":"DELETION","blobLineNumber":51,"text":"-NOTICE: in process utility: superuser attempting GrantStmt","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":51,"left":51,"right":50},{"stylingDirective":null,"type":"DELETION","blobLineNumber":52,"text":"-NOTICE: in process utility: superuser finished GrantStmt","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":52,"left":52,"right":50},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":51,"text":"+NOTICE: in process utility: superuser attempting REVOKE","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eREVOKE\u003c/span\u003e","displayNoNewLineWarning":false,"position":53,"left":52,"right":51},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":52,"text":"+NOTICE: in process utility: superuser finished REVOKE","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eREVOKE\u003c/span\u003e","displayNoNewLineWarning":false,"position":54,"left":52,"right":52},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":53,"text":" -- Check the behavior of the hooks relative to unrecognized parameters","html":" -- Check the behavior of the hooks relative to unrecognized parameters","displayNoNewLineWarning":false,"position":55,"left":53,"right":53},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":54,"text":" GRANT ALL ON PARAMETER \"none.such\" TO PUBLIC;","html":" GRANT ALL ON PARAMETER \u0026quot;none.such\u0026quot; TO PUBLIC;","displayNoNewLineWarning":false,"position":56,"left":54,"right":54},{"stylingDirective":null,"type":"DELETION","blobLineNumber":55,"text":"-NOTICE: in process utility: superuser attempting GrantStmt","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":57,"left":55,"right":54},{"stylingDirective":null,"type":"DELETION","blobLineNumber":56,"text":"-NOTICE: in process utility: superuser finished GrantStmt","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":58,"left":56,"right":54},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":55,"text":"+NOTICE: in process utility: superuser attempting GRANT","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eGRANT\u003c/span\u003e","displayNoNewLineWarning":false,"position":59,"left":56,"right":55},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":56,"text":"+NOTICE: in process utility: superuser finished GRANT","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eGRANT\u003c/span\u003e","displayNoNewLineWarning":false,"position":60,"left":56,"right":56},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":57,"text":" -- Check relative to an operation that causes the catalog entry to be deleted","html":" -- Check relative to an operation that causes the catalog entry to be deleted","displayNoNewLineWarning":false,"position":61,"left":57,"right":57},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":58,"text":" REVOKE ALL ON PARAMETER \"none.such\" FROM PUBLIC;","html":" REVOKE ALL ON PARAMETER \u0026quot;none.such\u0026quot; FROM PUBLIC;","displayNoNewLineWarning":false,"position":62,"left":58,"right":58},{"stylingDirective":null,"type":"DELETION","blobLineNumber":59,"text":"-NOTICE: in process utility: superuser attempting GrantStmt","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":63,"left":59,"right":58},{"stylingDirective":null,"type":"DELETION","blobLineNumber":60,"text":"-NOTICE: in process utility: superuser finished GrantStmt","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":64,"left":60,"right":58},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":59,"text":"+NOTICE: in process utility: superuser attempting REVOKE","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eREVOKE\u003c/span\u003e","displayNoNewLineWarning":false,"position":65,"left":60,"right":59},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":60,"text":"+NOTICE: in process utility: superuser finished REVOKE","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eREVOKE\u003c/span\u003e","displayNoNewLineWarning":false,"position":66,"left":60,"right":60},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":61,"text":" -- Create objects for use in the test","html":" -- Create objects for use in the test","displayNoNewLineWarning":false,"position":67,"left":61,"right":61},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":62,"text":" CREATE USER regress_test_user;","html":" CREATE USER regress_test_user;","displayNoNewLineWarning":false,"position":68,"left":62,"right":62},{"stylingDirective":null,"type":"DELETION","blobLineNumber":63,"text":"-NOTICE: in process utility: superuser attempting CreateRoleStmt","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eCreateRoleStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":69,"left":63,"right":62},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":63,"text":"+NOTICE: in process utility: superuser attempting CREATE ROLE","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eCREATE ROLE\u003c/span\u003e","displayNoNewLineWarning":false,"position":70,"left":63,"right":63},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":64,"text":" NOTICE: in object access: superuser attempting create (subId=0x0) [explicit]","html":" NOTICE: in object access: superuser attempting create (subId=0x0) [explicit]","displayNoNewLineWarning":false,"position":71,"left":64,"right":64},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":65,"text":" NOTICE: in object access: superuser finished create (subId=0x0) [explicit]","html":" NOTICE: in object access: superuser finished create (subId=0x0) [explicit]","displayNoNewLineWarning":false,"position":72,"left":65,"right":65},{"stylingDirective":null,"type":"DELETION","blobLineNumber":66,"text":"-NOTICE: in process utility: superuser finished CreateRoleStmt","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eCreateRoleStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":73,"left":66,"right":65},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":66,"text":"+NOTICE: in process utility: superuser finished CREATE ROLE","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eCREATE ROLE\u003c/span\u003e","displayNoNewLineWarning":false,"position":74,"left":66,"right":66},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":67,"text":" CREATE TABLE regress_test_table (t text);","html":" CREATE TABLE regress_test_table (t text);","displayNoNewLineWarning":false,"position":75,"left":67,"right":67},{"stylingDirective":null,"type":"DELETION","blobLineNumber":68,"text":"-NOTICE: in process utility: superuser attempting CreateStmt","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eCreateStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":76,"left":68,"right":67},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":68,"text":"+NOTICE: in process utility: superuser attempting CREATE TABLE","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eCREATE TABLE\u003c/span\u003e","displayNoNewLineWarning":false,"position":77,"left":68,"right":68},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":69,"text":" NOTICE: in object access: superuser attempting namespace search (subId=0x0) [no report on violation, allowed]","html":" NOTICE: in object access: superuser attempting namespace search (subId=0x0) [no report on violation, allowed]","displayNoNewLineWarning":false,"position":78,"left":69,"right":69},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":70,"text":" LINE 1: CREATE TABLE regress_test_table (t text);","html":" LINE 1: CREATE TABLE regress_test_table (t text);","displayNoNewLineWarning":false,"position":79,"left":70,"right":70},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":71,"text":" ^","html":" ^","displayNoNewLineWarning":false,"position":80,"left":71,"right":71},{"stylingDirective":null,"type":"HUNK","blobLineNumber":81,"text":"@@ -82,20 +82,20 @@ NOTICE: in object access: superuser attempting create (subId=0x0) [internal]","html":"@@ -82,20 +82,20 @@ NOTICE: in object access: superuser attempting create (subId=0x0) [internal]","displayNoNewLineWarning":false,"position":81,"left":81,"right":81},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":82,"text":" NOTICE: in object access: superuser finished create (subId=0x0) [internal]","html":" NOTICE: in object access: superuser finished create (subId=0x0) [internal]","displayNoNewLineWarning":false,"position":82,"left":82,"right":82},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":83,"text":" NOTICE: in object access: superuser attempting create (subId=0x0) [internal]","html":" NOTICE: in object access: superuser attempting create (subId=0x0) [internal]","displayNoNewLineWarning":false,"position":83,"left":83,"right":83},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":84,"text":" NOTICE: in object access: superuser finished create (subId=0x0) [internal]","html":" NOTICE: in object access: superuser finished create (subId=0x0) [internal]","displayNoNewLineWarning":false,"position":84,"left":84,"right":84},{"stylingDirective":null,"type":"DELETION","blobLineNumber":85,"text":"-NOTICE: in process utility: superuser finished CreateStmt","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eCreateStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":85,"left":85,"right":84},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":85,"text":"+NOTICE: in process utility: superuser finished CREATE TABLE","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eCREATE TABLE\u003c/span\u003e","displayNoNewLineWarning":false,"position":86,"left":85,"right":85},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":86,"text":" GRANT SELECT ON Table regress_test_table TO public;","html":" GRANT SELECT ON Table regress_test_table TO public;","displayNoNewLineWarning":false,"position":87,"left":86,"right":86},{"stylingDirective":null,"type":"DELETION","blobLineNumber":87,"text":"-NOTICE: in process utility: superuser attempting GrantStmt","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":88,"left":87,"right":86},{"stylingDirective":null,"type":"DELETION","blobLineNumber":88,"text":"-NOTICE: in process utility: superuser finished GrantStmt","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":89,"left":88,"right":86},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":87,"text":"+NOTICE: in process utility: superuser attempting GRANT","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eGRANT\u003c/span\u003e","displayNoNewLineWarning":false,"position":90,"left":88,"right":87},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":88,"text":"+NOTICE: in process utility: superuser finished GRANT","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eGRANT\u003c/span\u003e","displayNoNewLineWarning":false,"position":91,"left":88,"right":88},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":89,"text":" CREATE FUNCTION regress_test_func (t text) RETURNS text AS $$","html":" CREATE FUNCTION regress_test_func (t text) RETURNS text AS $$","displayNoNewLineWarning":false,"position":92,"left":89,"right":89},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":90,"text":" \tSELECT $1;","html":" \tSELECT $1;","displayNoNewLineWarning":false,"position":93,"left":90,"right":90},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":91,"text":" $$ LANGUAGE sql;","html":" $$ LANGUAGE sql;","displayNoNewLineWarning":false,"position":94,"left":91,"right":91},{"stylingDirective":null,"type":"DELETION","blobLineNumber":92,"text":"-NOTICE: in process utility: superuser attempting CreateFunctionStmt","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eCreateFunctionStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":95,"left":92,"right":91},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":92,"text":"+NOTICE: in process utility: superuser attempting CREATE FUNCTION","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eCREATE FUNCTION\u003c/span\u003e","displayNoNewLineWarning":false,"position":96,"left":92,"right":92},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":93,"text":" NOTICE: in object access: superuser attempting create (subId=0x0) [explicit]","html":" NOTICE: in object access: superuser attempting create (subId=0x0) [explicit]","displayNoNewLineWarning":false,"position":97,"left":93,"right":93},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":94,"text":" NOTICE: in object access: superuser finished create (subId=0x0) [explicit]","html":" NOTICE: in object access: superuser finished create (subId=0x0) [explicit]","displayNoNewLineWarning":false,"position":98,"left":94,"right":94},{"stylingDirective":null,"type":"DELETION","blobLineNumber"
8000
:95,"text":"-NOTICE: in process utility: superuser finished CreateFunctionStmt","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eCreateFunctionStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":99,"left":95,"right":94},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":95,"text":"+NOTICE: in process utility: superuser finished CREATE FUNCTION","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eCREATE FUNCTION\u003c/span\u003e","displayNoNewLineWarning":false,"position":100,"left":95,"right":95},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":96,"text":" GRANT EXECUTE ON FUNCTION regress_test_func (text) TO public;","html":" GRANT EXECUTE ON FUNCTION regress_test_func (text) TO public;","displayNoNewLineWarning":false,"position":101,"left":96,"right":96},{"stylingDirective":null,"type":"DELETION","blobLineNumber":97,"text":"-NOTICE: in process utility: superuser attempting GrantStmt","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":102,"left":97,"right":96},{"stylingDirective":null,"type":"DELETION","blobLineNumber":98,"text":"-NOTICE: in process utility: superuser finished GrantStmt","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eGrantStmt\u003c/span\u003e","displayNoNewLineWarning":false,"position":103,"left":98,"right":96},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":97,"text":"+NOTICE: in process utility: superuser attempting GRANT","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eGRANT\u003c/span\u003e","displayNoNewLineWarning":false,"position":104,"left":98,"right":97},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":98,"text":"+NOTICE: in process utility: superuser finished GRANT","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eGRANT\u003c/span\u003e","displayNoNewLineWarning":false,"position":105,"left":98,"right":98},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":99,"text":" -- Do a few things as superuser","html":" -- Do a few things as superuser","displayNoNewLineWarning":false,"position":106,"left":99,"right":99},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":100,"text":" SELECT * FROM regress_test_table;","html":" SELECT * FROM regress_test_table;","displayNoNewLineWarning":false,"position":107,"left":100,"right":100},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":101,"text":" NOTICE: in executor check perms: superuser attempting execute","html":" NOTICE: in executor check perms: superuser attempting execute","displayNoNewLineWarning":false,"position":108,"left":101,"right":101},{"stylingDirective":null,"type":"HUNK","blobLineNumber":112,"text":"@@ -113,31 +113,31 @@ NOTICE: in executor check perms: superuser finished execute","html":"@@ -113,31 +113,31 @@ NOTICE: in executor check perms: superuser finished execute","displayNoNewLineWarning":false,"position":109,"left":112,"right":112},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":113,"text":" (1 row)","html":" (1 row)","displayNoNewLineWarning":false,"position":110,"left":113,"right":113},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":114,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":111,"left":114,"right":114},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":115,"text":" SET work_mem = 8192;","html":" SET work_mem = 8192;","displayNoNewLineWarning":false,"position":112,"left":115,"right":115},{"stylingDirective":null,"type":"DELETION","blobLineNumber":116,"text":"-NOTICE: in process utility: superuser attempting set","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":113,"left":116,"right":115},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":116,"text":"+NOTICE: in process utility: superuser attempting SET","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":114,"left":116,"right":116},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":117,"text":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [work_mem]","html":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [work_mem]","displayNoNewLineWarning":false,"position":115,"left":117,"right":117},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":118,"text":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [work_mem]","html":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [work_mem]","displayNoNewLineWarning":false,"position":116,"left":118,"right":118},{"stylingDirective":null,"type":"DELETION","blobLineNumber":119,"text":"-NOTICE: in process utility: superuser finished set","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":117,"left":119,"right":118},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":119,"text":"+NOTICE: in process utility: superuser finished SET","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":118,"left":119,"right":119},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":120,"text":" RESET work_mem;","html":" RESET work_mem;","displayNoNewLineWarning":false,"position":119,"left":120,"right":120},{"stylingDirective":null,"type":"DELETION","blobLineNumber":121,"text":"-NOTICE: in process utility: superuser attempting set","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":120,"left":121,"right":120},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":121,"text":"+NOTICE: in process utility: superuser attempting RESET","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eRESET\u003c/span\u003e","displayNoNewLineWarning":false,"position":121,"left":121,"right":121},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":122,"text":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [work_mem]","html":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [work_mem]","displayNoNewLineWarning":false,"position":122,"left":122,"right":122},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":123,"text":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [work_mem]","html":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [work_mem]","displayNoNewLineWarning":false,"position":123,"left":123,"right":123},{"stylingDirective":null,"type":"DELETION","blobLineNumber":124,"text":"-NOTICE: in process utility: superuser finished set","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":124,"left":124,"right":123},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":124,"text":"+NOTICE: in process utility: superuser finished RESET","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eRESET\u003c/span\u003e","displayNoNewLineWarning":false,"position":125,"left":124,"right":124},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":125,"text":" ALTER SYSTEM SET work_mem = 8192;","html":" ALTER SYSTEM SET work_mem = 8192;","displayNoNewLineWarning":false,"position":126,"left":125,"right":125},{"stylingDirective":null,"type":"DELETION","blobLineNumber":126,"text":"-NOTICE: in process utility: superuser attempting alter system","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003ealter system\u003c/span\u003e","displayNoNewLineWarning":false,"position":127,"left":126,"right":125},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":126,"text":"+NOTICE: in process utility: superuser attempting ALTER SYSTEM","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eALTER SYSTEM\u003c/span\u003e","displayNoNewLineWarning":false,"position":128,"left":126,"right":126},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":127,"text":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x2000, alter system) [work_mem]","html":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x2000, alter system) [work_mem]","displayNoNewLineWarning":false,"position":129,"left":127,"right":127},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":128,"text":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x2000, alter system) [work_mem]","html":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x2000, alter system) [work_mem]","displayNoNewLineWarning":false,"position":130,"left":128,"right":128},{"stylingDirective":null,"type":"DELETION","blobLineNumber":129,"text":"-NOTICE: in process utility: superuser finished alter system","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003ealter system\u003c/span\u003e","displayNoNewLineWarning":false,"position":131,"left":129,"right":128},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":129,"text":"+NOTICE: in process utility: superuser finished ALTER SYSTEM","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eALTER SYSTEM\u003c/span\u003e","displayNoNewLineWarning":false,"position":132,"left":129,"right":129},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":130,"text":" ALTER SYSTEM RESET work_mem;","html":" ALTER SYSTEM RESET work_mem;","displayNoNewLineWarning":false,"position":133,"left":130,"right":130},{"stylingDirective":null,"type":"DELETION","blobLineNumber":131,"text":"-NOTICE: in process utility: superuser attempting alter system","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003ealter system\u003c/span\u003e","displayNoNewLineWarning":false,"position":134,"left":131,"right":130},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":131,"text":"+NOTICE: in process utility: superuser attempting ALTER SYSTEM","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eALTER SYSTEM\u003c/span\u003e","displayNoNewLineWarning":false,"position":135,"left":131,"right":131},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":132,"text":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x2000, alter system) [work_mem]","html":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x2000, alter system) [work_mem]","displayNoNewLineWarning":false,"position":136,"left":132,"right":132},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":133,"text":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x2000, alter system) [work_mem]","html":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x2000, alter system) [work_mem]","displayNoNewLineWarning":false,"position":137,"left":133,"right":133},{"stylingDirective":null,"type":"DELETION","blobLineNumber":134,"text":"-NOTICE: in process utility: superuser finished alter system","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003ealter system\u003c/span\u003e","displayNoNewLineWarning":false,"position":138,"left":134,"right":133},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":134,"text":"+NOTICE: in process utility: superuser finished ALTER SYSTEM","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eALTER SYSTEM\u003c/span\u003e","displayNoNewLineWarning":false,"position":139,"left":134,"right":134},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":135,"text":" -- Do those same things as non-superuser","html":" -- Do those same things as non-superuser","displayNoNewLineWarning":false,"position":140,"left":135,"right":135},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":136,"text":" SET SESSION AUTHORIZATION regress_test_user;","html":" SET SESSION AUTHORIZATION regress_test_user;","displayNoNewLineWarning":false,"position":141,"left":136,"right":136},{"stylingDirective":null,"type":"DELETION","blobLineNumber":137,"text":"-NOTICE: in process utility: superuser attempting set","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":142,"left":137,"right":136},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":137,"text":"+NOTICE: in process utility: superuser attempting SET","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":143,"left":137,"right":137},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":138,"text":" NOTICE: in object_access_hook_str: non-superuser attempting alter (subId=0x1000, set) [session_authorization]","html":" NOTICE: in object_access_hook_str: non-superuser attempting alter (subId=0x1000, set) [session_authorization]","displayNoNewLineWarning":false,"position":144,"left":138,"right":138},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":139,"text":" NOTICE: in object_access_hook_str: non-superuser finished alter (subId=0x1000, set) [session_authorization]","html":" NOTICE: in object_access_hook_str: non-superuser finished alter (subId=0x1000, set) [session_authorization]","displayNoNewLineWarning":false,"position":145,"left":139,"right":139},{"stylingDirective":null,"type":"DELETION","blobLineNumber":140,"text":"-NOTICE: in process utility: non-superuser finished set","html":"-NOTICE: in process utility: non-superuser finished \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":146,"left":140,"right":139},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":140,"text":"+NOTICE: in process utility: non-superuser finished SET","html":"+NOTICE: in process utility: non-superuser finished \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":147,"left":140,"right":140},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":141,"text":" SELECT * FROM regress_test_table;","html":" SELECT * FROM regress_test_table;","displayNoNewLineWarning":false,"position":148,"left":141,"right":141},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":142,"text":" NOTICE: in object access: non-superuser attempting namespace search (subId=0x0) [no report on violation, allowed]","html":" NOTICE: in object access: non-superuser attempting namespace search (subId=0x0) [no report on violation, allowed]","displayNoNewLineWarning":false,"position":149,"left":142,"right":142},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":143,"text":" LINE 1: SELECT * FROM regress_test_table;","html":" LINE 1: SELECT * FROM regress_test_table;","displayNoNewLineWarning":false,"position":150,"left":143,"right":143},{"stylingDirective":null,"type":"HUNK","blobLineNumber":159,"text":"@@ -160,83 +160,83 @@ NOTICE: in executor check perms: non-superuser finished execute","html":"@@ -160,83 +160,83 @@ NOTICE: in executor check perms: non-superuser finished execute","displayNoNewLineWarning":false,"position":151,"left":159,"right":159},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":160,"text":" (1 row)","html":" (1 row)","displayNoNewLineWarning":false,"position":152,"left":160,"right":160},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":161,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":153,"left":161,"right":161},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":162,"text":" SET work_mem = 8192;","html":" SET work_mem = 8192;","displayNoNewLineWarning":false,"position":154,"left":162,"right":162},{"stylingDirective":null,"type":"DELETION","blobLineNumber":163,"text":"-NOTICE: in process utility: non-superuser attempting set","html":"-NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":155,"left":163,"right":162},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":163,"text":"+NOTICE: in process utility: non-superuser attempting SET","html":"+NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":156,"left":163,"right":163},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":164,"text":" NOTICE: in object_access_hook_str: non-superuser attempting alter (subId=0x1000, set) [work_mem]","html":" NOTICE: in object_access_hook_str: non-superuser attempting alter (subId=0x1000, set) [work_mem]","displayNoNewLineWarning":false,"position":157,"left":164,"right":164},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":165,"text":" NOTICE: in object_access_hook_str: non-superuser finished alter (subId=0x1000, set) [work_mem]","html":" NOTICE: in object_access_hook_str: non-superuser finished alter (subId=0x1000, set) [work_mem]","displayNoNewLineWarning":false,"position":158,"left":165,"right":165},{"stylingDirective":null,"type":"DELETION","blobLineNumber":166,"text":"-NOTICE: in process utility: non-superuser finished set","html":"-NOTICE: in process utility: non-superuser finished \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":159,"left":166,"right":165},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":166,"text":"+NOTICE: in process utility: non-superuser finished SET","html":"+NOTICE: in process utility: non-superuser finished \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":160,"left":166,"right":166},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":167,"text":" RESET work_mem;","html":" RESET work_mem;","displayNoNewLineWarning":false,"position":161,"left":167,"right":167},{"stylingDirective":null,"type":"DELETION","blobLineNumber":168,"text":"-NOTICE: in process utility: non-superuser attempting set","html":"-NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":162,"left":168,"right":167},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":168,"text":"+NOTICE: in process utility: non-superuser attempting RESET","html":"+NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003eRESET\u003c/span\u003e","displayNoNewLineWarning":false,"position":163,"left":168,"right":168},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":169,"text":" NOTICE: in object_access_hook_str: non-superuser attempting alter (subId=0x1000, set) [work_mem]","html":" NOTICE: in object_access_hook_str: non-superuser attempting alter (subId=0x1000, set) [work_mem]","displayNoNewLineWarning":false,"position":164,"left":169,"right":169},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":170,"text":" NOTICE: in object_access_hook_str: non-superuser finished alter (subId=0x1000, set) [work_mem]","html":" NOTICE: in object_access_hook_str: non-superuser finished alter (subId=0x1000, set) [work_mem]","displayNoNewLineWarning":false,"position":165,"left":170,"right":170},{"stylingDirective":null,"type":"DELETION","blobLineNumber":171,"text":"-NOTICE: in process utility: non-superuser finished set","html":"-NOTICE: in process utility: non-superuser finished \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":166,"left":171,"right":170},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":171,"text":"+NOTICE: in process utility: non-superuser finished RESET","html":"+NOTICE: in process utility: non-superuser finished \u003cspan class=\"x x-first x-last\"\u003eRESET\u003c/span\u003e","displayNoNewLineWarning":false,"position":167,"left":171,"right":171},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":172,"text":" ALTER SYSTEM SET work_mem = 8192;","html":" ALTER SYSTEM SET work_mem = 8192;","displayNoNewLineWarning":false,"position":168,"left":172,"right":172},{"stylingDirective":null,"type":"DELETION","blobLineNumber":173,"text":"-NOTICE: in process utility: non-superuser attempting alter system","html":"-NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003ealter system\u003c/span\u003e","displayNoNewLineWarning":false,"position":169,"left":173,"right":172},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":173,"text":"+NOTICE: in process utility: non-superuser attempting ALTER SYSTEM","html":"+NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003eALTER SYSTEM\u003c/span\u003e","displayNoNewLineWarning":false,"position":170,"left":173,"right":173},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":174,"text":" ERROR: permission denied to set parameter \"work_mem\"","html":" ERROR: permission denied to set parameter \u0026quot;work_mem\u0026quot;","displayNoNewLineWarning":false,"position":171,"left":174,"right":174},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":175,"text":" ALTER SYSTEM RESET work_mem;","html":" ALTER SYSTEM RESET work_mem;","displayNoNewLineWarning":false,"position":172,"left":175,"right":175},{"stylingDirective":null,"type":"DELETION","blobLineNumber":176,"text":"-NOTICE: in process utility: non-superuser attempting alter system","html":"-NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003ealter system\u003c/span\u003e","displayNoNewLineWarning":false,"position":173,"left":176,"right":175},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":176,"text":"+NOTICE: in process utility: non-superuser attempting ALTER SYSTEM","html":"+NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003eALTER SYSTEM\u003c/span\u003e","displayNoNewLineWarning":false,"position":174,"left":176,"right":176},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":177,"text":" ERROR: permission denied to set parameter \"work_mem\"","html":" ERROR: permission denied to set parameter \u0026quot;work_mem\u0026quot;","displayNoNewLineWarning":false,"position":175,"left":177,"right":177},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":178,"text":" SET test_oat_hooks.user_var1 = true;","html":" SET test_oat_hooks.user_var1 = true;","displayNoNewLineWarning":false,"position":176,"left":178,"right":178},{"stylingDirective":null,"type":"DELETION","blobLineNumber":179,"text":"-NOTICE: in process utility: non-superuser attempting set","html":"-NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":177,"left":179,"right":178},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":179,"text":"+NOTICE: in process utility: non-superuser attempting SET","html":"+NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":178,"left":179,"right":179},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":180,"text":" NOTICE: in object_access_hook_str: non-superuser attempting alter (subId=0x1000, set) [test_oat_hooks.user_var1]","html":" NOTICE: in object_access_hook_str: non-superuser attempting alter (subId=0x1000, set) [test_oat_hooks.user_var1]","displayNoNewLineWarning":false,"position":179,"left":180,"right":180},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":181,"text":" NOTICE: in object_access_hook_str: non-superuser finished alter (subId=0x1000, set) [test_oat_hooks.user_var1]","html":" NOTICE: in object_access_hook_str: non-superuser finished alter (subId=0x1000, set) [test_oat_hooks.user_var1]","displayNoNewLineWarning":false,"position":180,"left":181,"right":181},{"stylingDirective":null,"type":"DELETION","blobLineNumber":182,"text":"-NOTICE: in process utility: non-superuser finished set","html":"-NOTICE: in process utility: non-superuser finished \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":181,"left":182,"right":181},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":182,"text":"+NOTICE: in process utility: non-superuser finished SET","html":"+NOTICE: in process utility: non-superuser finished \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":182,"left":182,"right":182},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":183,"text":" SET test_oat_hooks.super_var1 = true;","html":" SET test_oat_hooks.super_var1 = true;","displayNoNewLineWarning":false,"position":183,"left":183,"right":183},{"stylingDirective":null,"type":"DELETION","blobLineNumber":184,"text":"-NOTICE: in process utility: non-superuser attempting set","html":"-NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":184,"left":184,"right":183},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":184,"text":"+NOTICE: in process utility: non-superuser attempting SET","html":"+NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":185,"left":184,"right":184},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":185,"text":" ERROR: permission denied to set parameter \"test_oat_hooks.super_var1\"","html":" ERROR: permission denied to set parameter \u0026quot;test_oat_hooks.super_var1\u0026quot;","displayNoNewLineWarning":false,"position":186,"left":185,"right":185},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":186,"text":" ALTER SYSTEM SET test_oat_hooks.user_var1 = true;","html":" ALTER SYSTEM SET test_oat_hooks.user_var1 = true;","displayNoNewLineWarning":false,"position":187,"left":186,"right":186},{"stylingDirective":null,"type":"DELETION","blobLineNumber":187,"text":"-NOTICE: in process utility: non-superuser attempting alter system","html":"-NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003ealter system\u003c/span\u003e","displayNoNewLineWarning":false,"position":188,"left":187,"right":186},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":187,"text":"+NOTICE: in process utility: non-superuser attempting ALTER SYSTEM","html":"+NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003eALTER SYSTEM\u003c/span\u003e","displayNoNewLineWarning":false,"position":189,"left":187,"right":187},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":188,"text":" ERROR: permission denied to set parameter \"test_oat_hooks.user_var1\"","html":" ERROR: permission denied to set parameter \u0026quot;test_oat_hooks.user_var1\u0026quot;","displayNoNewLineWarning":false,"position":190,"left":188,"right":188},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":189,"text":" ALTER SYSTEM SET test_oat_hooks.super_var1 = true;","html":" ALTER SYSTEM SET test_oat_hooks.super_var1 = true;","displayNoNewLineWarning":false,"position":191,"left":189,"right":189},{"stylingDirective":null,"type":"DELETION","blobLineNumber":190,"text":"-NOTICE: in process utility: non-superuser attempting alter system","html":"-NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003ealter system\u003c/span\u003e","displayNoNewLineWarning":false,"position":192,"left":190,"right":189},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":190,"text":"+NOTICE: in process utility: non-superuser attempting ALTER SYSTEM","html":"+NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003eALTER SYSTEM\u003c/span\u003e","displayNoNewLineWarning":false,"position":193,"left":190,"right":190},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":191,"text":" ERROR: permission denied to set parameter \"test_oat_hooks.super_var1\"","html":" ERROR: permission denied to set parameter \u0026quot;test_oat_hooks.super_var1\u0026quot;","displayNoNewLineWarning":false,"position":194,"left":191,"right":191},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":192,"text":" SET test_oat_hooks.user_var2 = true;","html":" SET test_oat_hooks.user_var2 = true;","displayNoNewLineWarning":false,"position":195,"left":192,"right":192},{"stylingDirective":null,"type":"DELETION","blobLineNumber":193,"text":"-NOTICE: in process utility: non-superuser attempting set","html":"-NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":196,"left":193,"right":192},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":193,"text":"+NOTICE: in process utility: non-superuser attempting SET","html":"+NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":197,"left":193,"right":193},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":194,"text":" NOTICE: in object_access_hook_str: non-superuser attempting alter (subId=0x1000, set) [test_oat_hooks.user_var2]","html":" NOTICE: in object_access_hook_str: non-superuser attempting alter (subId=0x1000, set) [test_oat_hooks.user_var2]","displayNoNewLineWarning":false,"position":198,"left":194,"right":194},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":195,"text":" NOTICE: in object_access_hook_str: non-superuser finished alter (subId=0x1000, set) [test_oat_hooks.user_var2]","html":" NOTICE: in object_access_hook_str: non-superuser finished alter (subId=0x1000, set) [test_oat_hooks.user_var2]","displayNoNewLineWarning":false,"position":199,"left":195,"right":195},{"stylingDirective":null,"type":"DELETION","blobLineNumber":196,"text":"-NOTICE: in process utility: non-superuser finished set","html":"-NOTICE: in process utility: non-superuser finished \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":200,"left":196,"right":195},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":196,"text":"+NOTICE: in process utility: non-superuser finished SET","html":"+NOTICE: in process utility: non-superuser finished \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":201,"left":196,"right":196},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":197,"text":" SET test_oat_hooks.super_var2 = true;","html":" SET test_oat_hooks.super_var2 = true;","displayNoNewLineWarning":false,"position":202,"left":197,"right":197},{"stylingDirective":null,"type":"DELETION","blobLineNumber":198,"text":"-NOTICE: in process utility: non-superuser attempting set","html":"-NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":203,"left":198,"right":197},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":198,"text":"+NOTICE: in process utility: non-superuser attempting SET","html":"+NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":204,"left":198,"right":198},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":199,"text":" ERROR: permission denied to set parameter \"test_oat_hooks.super_var2\"","html":" ERROR: permission denied to set parameter \u
8000
0026quot;test_oat_hooks.super_var2\u0026quot;","displayNoNewLineWarning":false,"position":205,"left":199,"right":199},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":200,"text":" ALTER SYSTEM SET test_oat_hooks.user_var2 = true;","html":" ALTER SYSTEM SET test_oat_hooks.user_var2 = true;","displayNoNewLineWarning":false,"position":206,"left":200,"right":200},{"stylingDirective":null,"type":"DELETION","blobLineNumber":201,"text":"-NOTICE: in process utility: non-superuser attempting alter system","html":"-NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003ealter system\u003c/span\u003e","displayNoNewLineWarning":false,"position":207,"left":201,"right":200},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":201,"text":"+NOTICE: in process utility: non-superuser attempting ALTER SYSTEM","html":"+NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003eALTER SYSTEM\u003c/span\u003e","displayNoNewLineWarning":false,"position":208,"left":201,"right":201},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":202,"text":" ERROR: permission denied to set parameter \"test_oat_hooks.user_var2\"","html":" ERROR: permission denied to set parameter \u0026quot;test_oat_hooks.user_var2\u0026quot;","displayNoNewLineWarning":false,"position":209,"left":202,"right":202},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":203,"text":" ALTER SYSTEM SET test_oat_hooks.super_var2 = true;","html":" ALTER SYSTEM SET test_oat_hooks.super_var2 = true;","displayNoNewLineWarning":false,"position":210,"left":203,"right":203},{"stylingDirective":null,"type":"DELETION","blobLineNumber":204,"text":"-NOTICE: in process utility: non-superuser attempting alter system","html":"-NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003ealter system\u003c/span\u003e","displayNoNewLineWarning":false,"position":211,"left":204,"right":203},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":204,"text":"+NOTICE: in process utility: non-superuser attempting ALTER SYSTEM","html":"+NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003eALTER SYSTEM\u003c/span\u003e","displayNoNewLineWarning":false,"position":212,"left":204,"right":204},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":205,"text":" ERROR: permission denied to set parameter \"test_oat_hooks.super_var2\"","html":" ERROR: permission denied to set parameter \u0026quot;test_oat_hooks.super_var2\u0026quot;","displayNoNewLineWarning":false,"position":213,"left":205,"right":205},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":206,"text":" RESET SESSION AUTHORIZATION;","html":" RESET SESSION AUTHORIZATION;","displayNoNewLineWarning":false,"position":214,"left":206,"right":206},{"stylingDirective":null,"type":"DELETION","blobLineNumber":207,"text":"-NOTICE: in process utility: non-superuser attempting set","html":"-NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":215,"left":207,"right":206},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":207,"text":"+NOTICE: in process utility: non-superuser attempting RESET","html":"+NOTICE: in process utility: non-superuser attempting \u003cspan class=\"x x-first x-last\"\u003eRESET\u003c/span\u003e","displayNoNewLineWarning":false,"position":216,"left":207,"right":207},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":208,"text":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [session_authorization]","html":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [session_authorization]","displayNoNewLineWarning":false,"position":217,"left":208,"right":208},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":209,"text":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [session_authorization]","html":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [session_authorization]","displayNoNewLineWarning":false,"position":218,"left":209,"right":209},{"stylingDirective":null,"type":"DELETION","blobLineNumber":210,"text":"-NOTICE: in process utility: superuser finished set","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":219,"left":210,"right":209},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":210,"text":"+NOTICE: in process utility: superuser finished RESET","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eRESET\u003c/span\u003e","displayNoNewLineWarning":false,"position":220,"left":210,"right":210},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":211,"text":" -- Turn off non-superuser permissions","html":" -- Turn off non-superuser permissions","displayNoNewLineWarning":false,"position":221,"left":211,"right":211},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":212,"text":" SET test_oat_hooks.deny_set_variable = true;","html":" SET test_oat_hooks.deny_set_variable = true;","displayNoNewLineWarning":false,"position":222,"left":212,"right":212},{"stylingDirective":null,"type":"DELETION","blobLineNumber":213,"text":"-NOTICE: in process utility: superuser attempting set","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":223,"left":213,"right":212},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":213,"text":"+NOTICE: in process utility: superuser attempting SET","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":224,"left":213,"right":213},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":214,"text":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [test_oat_hooks.deny_set_variable]","html":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [test_oat_hooks.deny_set_variable]","displayNoNewLineWarning":false,"position":225,"left":214,"right":214},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":215,"text":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [test_oat_hooks.deny_set_variable]","html":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [test_oat_hooks.deny_set_variable]","displayNoNewLineWarning":false,"position":226,"left":215,"right":215},{"stylingDirective":null,"type":"DELETION","blobLineNumber":216,"text":"-NOTICE: in process utility: superuser finished set","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":227,"left":216,"right":215},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":216,"text":"+NOTICE: in process utility: superuser finished SET","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":228,"left":216,"right":216},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":217,"text":" SET test_oat_hooks.deny_alter_system = true;","html":" SET test_oat_hooks.deny_alter_system = true;","displayNoNewLineWarning":false,"position":229,"left":217,"right":217},{"stylingDirective":null,"type":"DELETION","blobLineNumber":218,"text":"-NOTICE: in process utility: superuser attempting set","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":230,"left":218,"right":217},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":218,"text":"+NOTICE: in process utility: superuser attempting SET","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":231,"left":218,"right":218},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":219,"text":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [test_oat_hooks.deny_alter_system]","html":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [test_oat_hooks.deny_alter_system]","displayNoNewLineWarning":false,"position":232,"left":219,"right":219},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":220,"text":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [test_oat_hooks.deny_alter_system]","html":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [test_oat_hooks.deny_alter_system]","displayNoNewLineWarning":false,"position":233,"left":220,"right":220},{"stylingDirective":null,"type":"DELETION","blobLineNumber":221,"text":"-NOTICE: in process utility: superuser finished set","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":234,"left":221,"right":220},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":221,"text":"+NOTICE: in process utility: superuser finished SET","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":235,"left":221,"right":221},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":222,"text":" SET test_oat_hooks.deny_object_access = true;","html":" SET test_oat_hooks.deny_object_access = true;","displayNoNewLineWarning":false,"position":236,"left":222,"right":222},{"stylingDirective":null,"type":"DELETION","blobLineNumber":223,"text":"-NOTICE: in process utility: superuser attempting set","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":237,"left":223,"right":222},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":223,"text":"+NOTICE: in process utility: superuser attempting SET","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":238,"left":223,"right":223},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":224,"text":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [test_oat_hooks.deny_object_access]","html":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [test_oat_hooks.deny_object_access]","displayNoNewLineWarning":false,"position":239,"left":224,"right":224},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":225,"text":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [test_oat_hooks.deny_object_access]","html":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [test_oat_hooks.deny_object_access]","displayNoNewLineWarning":false,"position":240,"left":225,"right":225},{"stylingDirective":null,"type":"DELETION","blobLineNumber":226,"text":"-NOTICE: in process utility: superuser finished set","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":241,"left":226,"right":225},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":226,"text":"+NOTICE: in process utility: superuser finished SET","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":242,"left":226,"right":226},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":227,"text":" SET test_oat_hooks.deny_exec_perms = true;","html":" SET test_oat_hooks.deny_exec_perms = true;","displayNoNewLineWarning":false,"position":243,"left":227,"right":227},{"stylingDirective":null,"type":"DELETION","blobLineNumber":228,"text":"-NOTICE: in process utility: superuser attempting set","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":244,"left":228,"right":227},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":228,"text":"+NOTICE: in process utility: superuser attempting SET","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":245,"left":228,"right":228},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":229,"text":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [test_oat_hooks.deny_exec_perms]","html":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [test_oat_hooks.deny_exec_perms]","displayNoNewLineWarning":false,"position":246,"left":229,"right":229},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":230,"text":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [test_oat_hooks.deny_exec_perms]","html":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [test_oat_hooks.deny_exec_perms]","displayNoNewLineWarning":false,"position":247,"left":230,"right":230},{"stylingDirective":null,"type":"DELETION","blobLineNumber":231,"text":"-NOTICE: in process utility: superuser finished set","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":248,"left":231,"right":230},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":231,"text":"+NOTICE: in process utility: superuser finished SET","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":249,"left":231,"right":231},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":232,"text":" SET test_oat_hooks.deny_utility_commands = true;","html":" SET test_oat_hooks.deny_utility_commands = true;","displayNoNewLineWarning":false,"position":250,"left":232,"right":232},{"stylingDirective":null,"type":"DELETION","blobLineNumber":233,"text":"-NOTICE: in process utility: superuser attempting set","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":251,"left":233,"right":232},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":233,"text":"+NOTICE: in process utility: superuser attempting SET","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":252,"left":233,"right":233},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":234,"text":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [test_oat_hooks.deny_utility_commands]","html":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [test_oat_hooks.deny_utility_commands]","displayNoNewLineWarning":false,"position":253,"left":234,"right":234},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":235,"text":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [test_oat_hooks.deny_utility_commands]","html":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [test_oat_hooks.deny_utility_commands]","displayNoNewLineWarning":false,"position":254,"left":235,"right":235},{"stylingDirective":null,"type":"DELETION","blobLineNumber":236,"text":"-NOTICE: in process utility: superuser finished set","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":255,"left":236,"right":235},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":236,"text":"+NOTICE: in process utility: superuser finished SET","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":256,"left":236,"right":236},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":237,"text":" -- Try again as non-superuser with permissions denied","html":" -- Try again as non-superuser with permissions denied","displayNoNewLineWarning":false,"position":257,"left":237,"right":237},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":238,"text":" SET SESSION AUTHORIZATION regress_test_user;","html":" SET SESSION AUTHORIZATION regress_test_user;","displayNoNewLineWarning":false,"position":258,"left":238,"right":238},{"stylingDirective":null,"type":"DELETION","blobLineNumber":239,"text":"-NOTICE: in process utility: superuser attempting set","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":259,"left":239,"right":238},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":239,"text":"+NOTICE: in process utility: superuser attempting SET","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":260,"left":239,"right":239},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":240,"text":" NOTICE: in object_access_hook_str: non-superuser attempting alter (subId=0x1000, set) [session_authorization]","html":" NOTICE: in object_access_hook_str: non-superuser attempting alter (subId=0x1000, set) [session_authorization]","displayNoNewLineWarning":false,"position":261,"left":240,"right":240},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":241,"text":" ERROR: permission denied: set session_authorization","html":" ERROR: permission denied: set session_authorization","displayNoNewLineWarning":false,"position":262,"left":241,"right":241},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":242,"text":" SELECT * FROM regress_test_table;","html":" SELECT * FROM regress_test_table;","displayNoNewLineWarning":false,"position":263,"left":242,"right":242},{"stylingDirective":null,"type":"HUNK","blobLineNumber":260,"text":"@@ -261,33 +261,33 @@ NOTICE: in executor check perms: superuser finished execute","html":"@@ -261,33 +261,33 @@ NOTICE: in executor check perms: superuser finished execute","displayNoNewLineWarning":false,"position":264,"left":260,"right":260},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":261,"text":" (1 row)","html":" (1 row)","displayNoNewLineWarning":false,"position":265,"left":261,"right":261},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":262,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":266,"left":262,"right":262},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":263,"text":" SET work_mem = 8192;","html":" SET work_mem = 8192;","displayNoNewLineWarning":false,"position":267,"left":263,"right":263},{"stylingDirective":null,"type":"DELETION","blobLineNumber":264,"text":"-NOTICE: in process utility: superuser attempting set","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":268,"left":264,"right":263},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":264,"text":"+NOTICE: in process utility: superuser attempting SET","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":269,"left":264,"right":264},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":265,"text":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [work_mem]","html":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [work_mem]","displayNoNewLineWarning":false,"position":270,"left":265,"right":265},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":266,"text":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [work_mem]","html":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [work_mem]","displayNoNewLineWarning":false,"position":271,"left":266,"right":266},{"stylingDirective":null,"type":"DELETION","blobLineNumber":267,"text":"-NOTICE: in process utility: superuser finished set","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":272,"left":267,"right":266},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":267,"text":"+NOTICE: in process utility: superuser finished SET","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":273,"left":267,"right":267},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":268,"text":" RESET work_mem;","html":" RESET work_mem;","displayNoNewLineWarning":false,"position":274,"left":268,"right":268},{"stylingDirective":null,"type":"DELETION","blobLineNumber":269,"text":"-NOTICE: in process utility: superuser attempting set","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":275,"left":269,"right":268},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":269,"text":"+NOTICE: in process utility: superuser attempting RESET","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eRESET\u003c/span\u003e","displayNoNewLineWarning":false,"position":276,"left":269,"right":269},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":270,"text":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [work_mem]","html":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [work_mem]","displayNoNewLineWarning":false,"position":277,"left":270,"right":270},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":271,"text":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [work_mem]","html":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [work_mem]","displayNoNewLineWarning":false,"position":278,"left":271,"right":271},{"stylingDirective":null,"type":"DELETION","blobLineNumber":272,"text":"-NOTICE: in process utility: superuser finished set","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":279,"left":272,"right":271},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":272,"text":"+NOTICE: in process utility: superuser finished RESET","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eRESET\u003c/span\u003e","displayNoNewLineWarning":false,"position":280,"left":272,"right":272},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":273,"text":" ALTER SYSTEM SET work_mem = 8192;","html":" ALTER SYSTEM SET work_mem = 8192;","displayNoNewLineWarning":false,"position":281,"left":273,"right":273},{"stylingDirective":null,"type":"DELETION","blobLineNumber":274,"text":"-NOTICE: in process utility: superuser attempting alter system","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003ealter system\u003c/span\u003e","displayNoNewLineWarning":false,"position":282,"left":274,"right":273},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":274,"text":"+NOTICE: in process utility: superuser attempting ALTER SYSTEM","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eALTER SYSTEM\u003c/span\u003e","displayNoNewLineWarning":false,"position":283,"left":274,"right":274},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":275,"text":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x2000, alter system) [work_mem]","html":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x2000, alter system) [work_mem]","displayNoNewLineWarning":false,"position":284,"left":275,"right":275},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":276,"text":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x2000, alter system) [work_mem]","html":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x2000, alter system) [work_mem]","displayNoNewLineWarning":false,"position":285,"left":276,"right":276},{"stylingDirective":null,"type":"DELETION","blobLineNumber":277,"text":"-NOTICE: in process utility: superuser finished alter system","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003ealter system\u003c/span\u003e","displayNoNewLineWarning":false,"position":286,"left":277,"right":276},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":277,"text":"+NOTICE: in process utility: superuser finished ALTER SYSTEM","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eALTER SYSTEM\u003c/span\u003e","displayNoNewLineWarning":false,"position":287,"left":277,"right":277},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":278,"text":" ALTER SYSTEM RESET work_mem;","html":" ALTER SYSTEM RESET work_mem;","displayNoNewLineWarning":false,"position":288,"left":278,"right":278},{"stylingDirective":null,"type":"DELETION","blobLineNumber":279,"text":"-NOTICE: in process utility: superuser attempting alter system","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003ealter system\u003c/span\u003e","displayNoNewLineWarning":false,"position":289,"left":279,"right":278},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":279,"text":"+NOTICE: in process utility: superuser attempting ALTER SYSTEM","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eALTER SYSTEM\u003c/span\u003e","displayNoNewLineWarning":false,"position":290,"left":279,"right":279},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":280,"text":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x2000, alter system) [work_mem]","html":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x2000, alter system) [work_mem]","displayNoNewLineWarning":false,"position":291,"left":280,"right":280},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":281,"text":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x2000, alter system) [work_mem]","html":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x2000, alter system) [work_mem]","displayNoNewLineWarning":false,"position":292,"left":281,"right":281},{"stylingDirective":null,"type":"DELETION","blobLineNumber":282,"text":"-NOTICE: in process utility: superuser finished alter system","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003ealter system\u003c/span\u003e","displayNoNewLineWarning":false,"position":293,"left":282,"right":281},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":282,"text":"+NOTICE: in process utility: superuser finished ALTER SYSTEM","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eALTER SYSTEM\u003c/span\u003e","displayNoNewLineWarning":false,"position":294,"left":282,"right":282},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":283,"text":" -- Clean up","html":" -- Clean up","displayNoNewLineWarning":false,"position":295,"left":283,"right":283},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":284,"text":" RESET SESSION AUTHORIZATION;","html":" RESET SESSION AUTHORIZATION;","displayNoNewLineWarning":false,"position":296,"left":284,"right":284},{"stylingDirective":null,"type":"DELETION","blobLineNumber":285,"text":"-NOTICE: in process utility: superuser attempting set","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":297,"left":285,"right":284},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":285,"text":"+NOTICE: in process utility: superuser attempting RESET","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eRESET\u003c/span\u003e","displayNoNewLineWarning":false,"position":298,"left":285,"right":285},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":286,"text":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [session_authorization]","html":" NOTICE: in object_access_hook_str: superuser attempting alter (subId=0x1000, set) [session_authorization]","displayNoNewLineWarning":false,"position":299,"left":286,"right":286},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":287,"text":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [session_authorization]","html":" NOTICE: in object_access_hook_str: superuser finished alter (subId=0x1000, set) [session_authorization]","displayNoNewLineWarning":false,"position":300,"left":287,"right":287},{"stylingDirective":null,"type":"DELETION","blobLineNumber":288,"text":"-NOTICE: in process utility: superuser finished set","html":"-NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":301,"left":288,"right":287},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":288,"text":"+NOTICE: in process utility: superuser finished RESET","html":"+NOTICE: in process utility: superuser finished \u003cspan class=\"x x-first x-last\"\u003eRESET\u003c/span\u003e","displayNoNewLineWarning":false,"position":302,"left":288,"right":288},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":289,"text":" SET test_oat_hooks.audit = false;","html":" SET test_oat_hooks.audit = false;","displayNoNewLineWarning":false,"position":303,"left":289,"right":289},{"stylingDirective":null,"type":"DELETION","blobLineNumber":290,"text":"-NOTICE: in process utility: superuser attempting set","html":"-NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eset\u003c/span\u003e","displayNoNewLineWarning":false,"position":304,"left":290,"right":289},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":290,"text":"+NOTICE: in process utility: superuser attempting SET","html":"+NOTICE: in process utility: superuser attempting \u003cspan class=\"x x-first x-last\"\u003eSET\u003c/span\u003e","displayNoNewLineWarning":false,"position":305,"left":290,"right":290},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":291,"text":" DROP ROLE regress_role_joe; -- fails","html":" DROP ROLE regress_role_joe; -- fails","displayNoNewLineWarning":false,"position":306,"left":291,"right":291},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":292,"text":" ERROR: role \"regress_role_joe\" cannot be dropped because some objects depend on it","html":" ERROR: role \u0026quot;regress_role_joe\u0026quot; cannot be dropped because some objects depend on it","displayNoNewLineWarning":false,"position":307,"left":292,"right":292},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":293,"text":" DETAIL: privileges for parameter test_oat_hooks.user_var1","html":" DETAIL: privileges for parameter test_oat_hooks.user_var1","displayNoNewLineWarning":false,"position":308,"left":293,"right":293}],"diffNumber":0,"diffSize":"0 Bytes","isBinary":false,"isTooBig":false,"collapsed":false,"isSubmodule":false,"lineCount":305,"linesChanged":160,"newTreeEntry":{"lineCount":305,"path":"src/test/modules/test_oat_hooks/expected/test_oat_hooks.out","mode":100644,"isGenerated":false},"oldTreeEntry":{"lineCount":0,"path":"src/test/modules/test_oat_hooks/expected/test_oat_hooks.out","mode":100644},"linesAd
8000
ded":80,"linesDeleted":80,"path":"src/test/modules/test_oat_hooks/expected/test_oat_hooks.out","pathDigest":"b50235a62cf87ef990c9cd83912efcd0bbb3fe9f3182354d5a7481e121729f39","status":"MODIFIED","truncatedReason":null,"oldOid":"9c9fc20e6fdf34d480b55bd517487b0affbf18e0","newOid":"6e37312a2a595b7f75e1190b2d15e88d54b366a7","copilotChatReference":null,"deletedSha":"9c9fc20e6fdf34d480b55bd517487b0affbf18e0","canToggleRichDiff":false,"defaultToRichDiff":false,"proseDifffHtml":null,"renderInfo":null,"dependencyDiffPath":null,"submodule":null},{"path":"src/test/modules/test_oat_hooks/test_oat_hooks.c","pathDigest":"10cd338c7f63622b97319754d356c9c7344041252ba25ac28b34fcc99f42f700","status":"MODIFIED"}],"splitViewPreference":"unified","ignoreWhitespace":false,"repoOwnerGlobalRelayId":"MDEyOk9yZ2FuaXphdGlvbjE3NzU0Mw==","commentsPreference":"visible","diffLineSpacingPreference":"relaxed","useMonospaceFont":false,"pasteUrlLinkAsPlainText":false,"userNotices":[],"path":"/postgres/postgres/commit/6e37312a2a595b7f75e1190b2d15e88d54b366a7","fileTreeExpanded":true,"headerInfo":{"additions":81,"deletions":1407,"filesChanged":2,"filesChangedString":"2"},"moreDiffsToLoad":true,"asyncDiffLoadInfo":{"startIndex":1,"truncated":false,"byteCount":19389,"lineShownCount":309},"commentInfo":{"canComment":false,"locked":false,"canLock":false,"repoArchived":false},"csrf_tokens":{"/users/diffview?diff=split":{"post":"_uM3g_zUTR9BkikZXdpJZrgFKZS0O7r6oTaG_QrS1tzDP0Id20gR148YGIsgoRkgnvVmkcv9Q9Y-oRWsUCSBWg"},"/users/diffview?diff=unified":{"post":"2CUsJojQRRL0L6WV8OFT5Box1lcarT-nUsS99PVao73l-Vm4r0wZ2jqllAeNmgOiPMGZUmVrxovNUy6lr6z0Ow"},"/notifications/thread":{"post":"Pa5l3zo3yx4xSEsdNuomvWvYumrPP8KvQi6qknj0ORaL4HnCFSTRGXf_GfYl78Rv9X6_H6U4ExeBV3CXTzB_Kg"}}},"title":"Remove test_oat_hooks.c's nodetag_to_string(). · postgres/postgres@6e37312","appPayload":{"helpUrl":"https://docs.github.com","findInDiffWorkerPath":"/assets-cdn/worker/find-in-diff-worker-2bfe39677d14.js","enabled_features":{"diff_ux_refresh_beta":false,"diff_inline_comments":true,"diff_ux_refresh_ssr_five":false,"diff_ux_refresh_ssr_ten":false,"react_diff_line_type_character_correction":true}}}
In the short time this function has existed, it's already proven to be
a nontrivial maintenance burden, since it has to be updated whenever a
node tag is added or removed. Although in principle we could now
automate that, I see little justification for having such functionality
here at all. The function is only being applied to utility statements,
for which we already have infrastructure for obtaining string names.
Moreover, that infrastructure produces already-familiar-to-users names,
unlike nodetag_to_string().
So, remove this function and use the existing infrastructure instead.
That saves over a thousand lines of largely-unreachable code.
Back-patch to v15 where this code came in. Although it seems unlikely
that v15's nodetag list will change anymore, we might as well keep the
two branches looking and acting alike; otherwise back-patching any
test-results changes in this area will be painful.
Discussion: https://postgr.es/m/843818.1659218928@sss.pgh.pa.us
0 commit comments