{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":88354535,"defaultBranch":"main","name":"pgsodium","ownerLogin":"michelp","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2017-04-15T15:06:39.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/123017?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1699659452.0","currentOid":""},"activityList":{"items":[{"before":"41ef82c6d4a3d4e35a3a1d9c31588e7b024e7fb6","after":"7222ebc5ed87084a68d526aef977be0f4eb319a2","ref":"refs/heads/main","pushedAt":"2023-11-10T22:45:39.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"upsert pattern documentation. (#99)\n\nCo-authored-by: Michel Pelletier <michel@graphegon.com>","shortMessageHtmlLink":"upsert pattern documentation. (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1988482321\" data-permission-text=\"Title is private\" data-url=\"https://github.com/michelp/pgsodium/issues/99\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/michelp/pgsodium/pull/99/hovercard\" href=\"https://github.com/michelp/pgsodium/pull/99\">#99</a>)"}},{"before":null,"after":"63ca6d912b5ba520ad9ada327cc05bb772043c93","ref":"refs/heads/michelp/readme-updates-3.1.9-2","pushedAt":"2023-11-10T22:08:58.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"upsert pattern documentation.","shortMessageHtmlLink":"upsert pattern documentation."}},{"before":"21c2eea0d06e9183abc55092226acdb60cc9e58d","after":"41ef82c6d4a3d4e35a3a1d9c31588e7b024e7fb6","ref":"refs/heads/main","pushedAt":"2023-11-02T16:40:53.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"update readme. (#97)\n\nCo-authored-by: Michel Pelletier <michel@graphegon.com>","shortMessageHtmlLink":"update readme. (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1974537840\" data-permission-text=\"Title is private\" data-url=\"https://github.com/michelp/pgsodium/issues/97\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/michelp/pgsodium/pull/97/hovercard\" href=\"https://github.com/michelp/pgsodium/pull/97\">#97</a>)"}},{"before":null,"after":"fd347b9ee150e6a72ca4d212be57d4ef5c944a1b","ref":"refs/heads/michelp/readme-updates-3.1.9","pushedAt":"2023-11-02T15:45:11.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"update readme.","shortMessageHtmlLink":"update readme."}},{"before":"91d7e900bea019e3f5ae603d4773684274427b29","after":"21c2eea0d06e9183abc55092226acdb60cc9e58d","ref":"refs/heads/main","pushedAt":"2023-11-01T18:43:49.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"Update test runner for pg 16 and add pgsodium.seclabel view easily see labled columns. (#93)\n\nCo-authored-by: Michel Pelletier <michel@levy.net>","shortMessageHtmlLink":"Update test runner for pg 16 and add pgsodium.seclabel view easily se…"}},{"before":"a00a493df4700c706ab2f2ea504fc6fd3ce187a5","after":"5b955b8a25b4d0927f12e59e46730eb12594fdb9","ref":"refs/heads/michelp/pg-16-seclabel-view","pushedAt":"2023-11-01T17:33:04.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"merge main","shortMessageHtmlLink":"merge main"}},{"before":"dc411abdd167faecaa500ff297f6c30c14a36f9b","after":"91d7e900bea019e3f5ae603d4773684274427b29","ref":"refs/heads/main","pushedAt":"2023-11-01T17:07:01.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"Add config var to enable or disable event trigger function. (#94)\n\n* Add config var to enable or disable event trigger function.\r\n\r\n* add helper view to easily show labeled columns.\r\n\r\n* catch empty strings or bytes and throw error.","shortMessageHtmlLink":"Add config var to enable or disable event trigger function. (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1919743584\" data-permission-text=\"Title is private\" data-url=\"https://github.com/michelp/pgsodium/issues/94\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/michelp/pgsodium/pull/94/hovercard\" href=\"https://github.com/michelp/pgsodium/pull/94\">#94</a>)"}},{"before":"6524209d5f1f9934307b5270a9b538ecbcb7ec23","after":"8fec16a39f445ca2912dccadf76d58d680ea7914","ref":"refs/heads/michelp/event-trigger-config-var","pushedAt":"2023-10-04T15:07:44.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"catch empty strings or bytes and throw error.","shortMessageHtmlLink":"catch empty strings or bytes and throw error."}},{"before":"3a01bad214fab20977c0df44548d9db2a83678b7","after":"6524209d5f1f9934307b5270a9b538ecbcb7ec23","ref":"refs/heads/michelp/event-trigger-config-var","pushedAt":"2023-10-04T14:23:57.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"add helper view to easily show labeled columns.","shortMessageHtmlLink":"add helper view to easily show labeled columns."}},{"before":null,"after":"3a01bad214fab20977c0df44548d9db2a83678b7","ref":"refs/heads/michelp/event-trigger-config-var","pushedAt":"2023-09-29T18:13:34.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"Add config var to enable or disable event trigger function.","shortMessageHtmlLink":"Add config var to enable or disable event trigger function."}},{"before":null,"after":"a00a493df4700c706ab2f2ea504fc6fd3ce187a5","ref":"refs/heads/michelp/pg-16-seclabel-view","pushedAt":"2023-09-20T17:58:51.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"Update test runner for pg 16 and add pgsodium.seclabel view easily see labled columns.","shortMessageHtmlLink":"Update test runner for pg 16 and add pgsodium.seclabel view easily se…"}},{"before":"54ee412bfb6aa41397b303be0dacba332f530eb2","after":"dc411abdd167faecaa500ff297f6c30c14a36f9b","ref":"refs/heads/main","pushedAt":"2023-09-20T01:29:30.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"Support building pgsodium on windows (#72)\n\n* adding scripts to generate root secret key\r\n\r\n* add PGDLLEXPORT\r\n\r\n* support executing and reading getkey_script on windows\r\n\r\n* add visual studio solution/project files\r\n\r\n* add windows build instructions and update gitignore\r\n\r\n* remove nonfunctional powershell root key script\r\n\r\n* use compiler defined _WIN32\r\n\r\n* remove check for write permissions\r\n\r\n* define getline function for windows builds\r\n\r\n* update windows build process to use msbuild from the command line\r\n\r\n* - Adding github action to build pgsodium using msbuild and the v143 platform toolset\r\n- Unit tests do not yet run, requires pgtap\r\n\r\n* windows tests: adding pgtap and running test suite\r\n\r\n---------\r\n\r\nCo-authored-by: Michel Pelletier <michelp@users.noreply.github.com>","shortMessageHtmlLink":"Support building pgsodium on windows (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1575060596\" data-permission-text=\"Title is private\" data-url=\"https://github.com/michelp/pgsodium/issues/72\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/michelp/pgsodium/pull/72/hovercard\" href=\"https://github.com/michelp/pgsodium/pull/72\">#72</a>)"}},{"before":"54c06acf3ad06cc5c9c77d350cf58c7c25052454","after":"54ee412bfb6aa41397b303be0dacba332f530eb2","ref":"refs/heads/main","pushedAt":"2023-09-20T00:41:00.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"Fix the 'role does not exist' error caused by uppercase characters in user (#90)","shortMessageHtmlLink":"Fix the 'role does not exist' error caused by uppercase characters in…"}},{"before":"9ab96e1d3285bf6abd7744940b6bbe6fba6e45e0","after":"54c06acf3ad06cc5c9c77d350cf58c7c25052454","ref":"refs/heads/main","pushedAt":"2023-07-17T21:56:23.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"Fix/trg fire only altered masks (#89)\n\n* checkpoint to pause this work and cherry pick out trigger fix.\r\n\r\n* cherry pick only trigger fix.\r\n\r\n* schema updates","shortMessageHtmlLink":"Fix/trg fire only altered masks (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1808357621\" data-permission-text=\"Title is private\" data-url=\"https://github.com/michelp/pgsodium/issues/89\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/michelp/pgsodium/pull/89/hovercard\" href=\"https://github.com/michelp/pgsodium/pull/89\">#89</a>)"}},{"before":null,"after":"5a9afa336980a343c1d5e0d1bbc731525dffcb37","ref":"refs/heads/fix/trg-fire-only-altered-masks","pushedAt":"2023-07-17T18:26:47.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"schema updates","shortMessageHtmlLink":"schema updates"}},{"before":null,"after":"c87f1d57635a4b02cdff663d56d8bf8dec785822","ref":"refs/heads/fix/only-fire-event-trigger-on-labled","pushedAt":"2023-06-15T17:25:41.523Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"Only fire update_masks() when labled tables are present in effected ddl command list.","shortMessageHtmlLink":"Only fire update_masks() when labled tables are present in effected d…"}},{"before":"0d8508e5ec0af09a0b66dc30bbc34a46d670a373","after":"a4f0aafd19d5cf1fc7c6ad74fb87f7615491b648","ref":"refs/heads/feat/signcryption-tokens","pushedAt":"2023-06-15T16:38:36.256Z","pushType":"push","commitsCount":13,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"merge main partial push for 3.2.0","shortMessageHtmlLink":"merge main partial push for 3.2.0"}},{"before":"b84ee308b9b091e2dfdc2af86a17dc7438b4af7e","after":"9ab96e1d3285bf6abd7744940b6bbe6fba6e45e0","ref":"refs/heads/main","pushedAt":"2023-06-08T17:24:15.272Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"Fix tests for 3.1.7 (#83)\n\n* Fix test error on schema caused by pgtap bug\r\n\r\nBug reported to pgtap upstream here:\r\n\r\n  https://github.com/theory/pgtap/pull/311\r\n\r\n* Test minimal postgresql supported version\r\n\r\n* Fix test failing because of objects order\r\n\r\nthe test can fail when running the test on a database with\r\na different collation than the one used to write the test.\r\n\r\n* Fix SQL error with pg 16\r\n\r\n* Fix test errors with pg_read_all_data and pg_write_all_data roles\r\n\r\n* Update pgsodium version in test generator\r\n\r\n* Add tests about masking_rule.security_invoker column\r\n\r\n* Comply tests generator and SQL schema to the new test.sql script\r\n\r\n* Create role and extension inside the test's transaction\r\n\r\n* Create pgsodium extension outside of the transaction\r\n\r\nWhen creating the extension inside the xact, one test is failing with\r\nthe following error:\r\n\r\n  ERROR:  unsafe use of new value \"secretbox\" of enum type key_type\r\n  LINE 1: SELECT id as secretbox_key_id from create_key('secretbox')\r\n                                                      ^\r\n  HINT:  New enum values must be committed before they can be used\r\n\r\n* Make volumes accessible inside the container with podman","shortMessageHtmlLink":"Fix tests for 3.1.7 (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1747896333\" data-permission-text=\"Title is private\" data-url=\"https://github.com/michelp/pgsodium/issues/83\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/michelp/pgsodium/pull/83/hovercard\" href=\"https://github.com/michelp/pgsodium/pull/83\">#83</a>)"}},{"before":"c443019fd410a50290de8e4973dd8c3773e1a85d","after":"b84ee308b9b091e2dfdc2af86a17dc7438b4af7e","ref":"refs/heads/main","pushedAt":"2023-05-29T18:27:11.440Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"security invoker support for dynamic views pg 15+ (#82)\n\n* security invoker support for dynamic views pg 15+\r\n\r\n* only fire security invoker tests on pg15\r\n\r\n* quiet test runner.\r\n\r\n* convert tests to use pg_prove","shortMessageHtmlLink":"security invoker support for dynamic views pg 15+ (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1724948099\" data-permission-text=\"Title is private\" data-url=\"https://github.com/michelp/pgsodium/issues/82\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/michelp/pgsodium/pull/82/hovercard\" href=\"https://github.com/michelp/pgsodium/pull/82\">#82</a>)"}},{"before":"e837419e7ac8cc93e606b1f19fe9011762dac2c8","after":"a25e7af2ff4ab9a959cf82f9387942da3ad1e7bd","ref":"refs/heads/feat/security-invoker-tce-view","pushedAt":"2023-05-29T15:09:52.329Z","pushType":"push","commitsCount":1,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"convert tests to use pg_prove","shortMessageHtmlLink":"convert tests to use pg_prove"}},{"before":"be815289dcfacb7d6996ed77e21f92d046345d02","after":"e837419e7ac8cc93e606b1f19fe9011762dac2c8","ref":"refs/heads/feat/security-invoker-tce-view","pushedAt":"2023-05-25T03:50:01.702Z","pushType":"push","commitsCount":1,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"quiet test runner.","shortMessageHtmlLink":"quiet test runner."}},{"before":"5a3e4e24cecaa96148d969f678b963a191a4c5b9","after":"be815289dcfacb7d6996ed77e21f92d046345d02","ref":"refs/heads/feat/security-invoker-tce-view","pushedAt":"2023-05-25T02:42:48.708Z","pushType":"push","commitsCount":1,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"only fire security invoker tests on pg15","shortMessageHtmlLink":"only fire security invoker tests on pg15"}},{"before":null,"after":"5a3e4e24cecaa96148d969f678b963a191a4c5b9","ref":"refs/heads/feat/security-invoker-tce-view","pushedAt":"2023-05-25T01:36:40.690Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"security invoker support for dynamic views pg 15+","shortMessageHtmlLink":"security invoker support for dynamic views pg 15+"}},{"before":"99d5f22e5590143fb7880cdb207c2b7fe72256e5","after":"c443019fd410a50290de8e4973dd8c3773e1a85d","ref":"refs/heads/main","pushedAt":"2023-04-03T22:02:40.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"dump key id sequence, update test to 3.1.6 (#80)","shortMessageHtmlLink":"dump key id sequence, update test to 3.1.6 (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"1652809438\" data-permission-text=\"Title is private\" data-url=\"https://github.com/michelp/pgsodium/issues/80\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/michelp/pgsodium/pull/80/hovercard\" href=\"https://github.com/michelp/pgsodium/pull/80\">#80</a>)"}},{"before":null,"after":"fb9c8200013ad3752316ca7a16a1dd41a2e4133b","ref":"refs/heads/fix/key-id-dump-config","pushedAt":"2023-04-03T21:11:11.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"michelp","name":"Michel Pelletier","path":"/michelp","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/123017?s=80&v=4"},"commit":{"message":"dump key id sequence, update test to 3.1.6","shortMessageHtmlLink":"dump key id sequence, update test to 3.1.6"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAADrJFwQgA","startCursor":null,"endCursor":null}},"title":"Activity · michelp/pgsodium"}