{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":67372977,"defaultBranch":"main","name":"pg_cron","ownerLogin":"citusdata","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2016-09-04T23:12:31.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/2545424?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1723208677.0","currentOid":""},"activityList":{"items":[{"before":"f6ab30eb129c3d9c6f9d0a36f53cb7c784eb90be","after":"f5d111117ddc0f4d83a1bad34d61b857681b6720","ref":"refs/heads/main","pushedAt":"2024-08-22T15:10:56.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"marcoslot","name":"Marco Slot","path":"/marcoslot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/529570?s=80&v=4"},"commit":{"message":"Updated readme to show that Instaclustr now supports pg_cron (#348)\n\nCo-authored-by: Chris Carter \r\nCo-authored-by: Marco Slot ","shortMessageHtmlLink":"Updated readme to show that Instaclustr now supports pg_cron (#348)"}},{"before":"3a314861c523a6ebdd9e948a90645034cd085d29","after":"f6ab30eb129c3d9c6f9d0a36f53cb7c784eb90be","ref":"refs/heads/main","pushedAt":"2024-08-22T13:32:56.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"marcoslot","name":"Marco Slot","path":"/marcoslot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/529570?s=80&v=4"},"commit":{"message":"Merge pull request #330 from hari90/AddYugabyte\n\nAdd YugabyteDB to list of supported services","shortMessageHtmlLink":"Merge pull request #330 from hari90/AddYugabyte"}},{"before":"9490f9cc9803f75105f2f7d89839a998f011f8d8","after":"3a314861c523a6ebdd9e948a90645034cd085d29","ref":"refs/heads/main","pushedAt":"2024-08-22T10:05:21.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"marcoslot","name":"Marco Slot","path":"/marcoslot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/529570?s=80&v=4"},"commit":{"message":"Add bounds checks on step size","shortMessageHtmlLink":"Add bounds checks on step size"}},{"before":"14bfd0b9a45e93ee50752816836e4b4e663d1420","after":"9490f9cc9803f75105f2f7d89839a998f011f8d8","ref":"refs/heads/main","pushedAt":"2024-08-09T12:58:17.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"marcoslot","name":"Marco Slot","path":"/marcoslot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/529570?s=80&v=4"},"commit":{"message":"Revert \"Remove unnecessary lastStartTime reset\"\n\nThis reverts commit d90843de92d5e517a23b1e17da56dc08c496c774.","shortMessageHtmlLink":"Revert \"Remove unnecessary lastStartTime reset\""}},{"before":"bd0196a86434ffba9de90b0c08d34e27170d5f71","after":null,"ref":"refs/heads/compat/1.4","pushedAt":"2024-08-09T12:57:34.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"marcoslot","name":"Marco Slot","path":"/marcoslot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/529570?s=80&v=4"}},{"before":"e5eb77e8634cb41b2b16e71c6320cfe637ec3043","after":"14bfd0b9a45e93ee50752816836e4b4e663d1420","ref":"refs/heads/main","pushedAt":"2024-08-09T12:57:32.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"marcoslot","name":"Marco Slot","path":"/marcoslot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/529570?s=80&v=4"},"commit":{"message":"Merge pull request #347 from citusdata/compat/1.4\n\nSelect procedure based on argument type of cron_unschedule_named","shortMessageHtmlLink":"Merge pull request #347 from citusdata/compat/1.4"}},{"before":"94063c64cff8e68c0b2b165c8852d6863b9a7bf4","after":"bd0196a86434ffba9de90b0c08d34e27170d5f71","ref":"refs/heads/compat/1.4","pushedAt":"2024-08-09T11:57:44.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"CyberDem0n","name":"Alexander Kukushkin","path":"/CyberDem0n","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/3407345?s=80&v=4"},"commit":{"message":"Select procedure based on argument type of cron_unschedule_named\n\nThe #299 PR took care of bacward compatibility of the function, but\nthere is still one problem left. If extension isn't updated type of the\njobname field in the cron.job table is still NAME, and as a result scan\nwas failing to find rows and unschedule a named job.\n\nThis fix is relying on the fact that SQL API of the unschedule()\nfunction is updated consistently with the cron.job table definition.","shortMessageHtmlLink":"Select procedure based on argument type of cron_unschedule_named"}},{"before":"b618b116c379e324fbba498e3bbfbb801218a0fd","after":"94063c64cff8e68c0b2b165c8852d6863b9a7bf4","ref":"refs/heads/compat/1.4","pushedAt":"2024-08-09T11:56:59.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"CyberDem0n","name":"Alexander Kukushkin","path":"/CyberDem0n","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/3407345?s=80&v=4"},"commit":{"message":"Select procedure based on argument type of cron_unschedule_named\n\nThe #299 PR took care of bacward compatibility of the function, but\nthere is still one problem left. If extension isn't updated type of the\njobname field in the cron.job table is still NAME, and as a result scan\nwas failing to find rows and unschedule a named job.\n\nThis fix is relying on the fact that SQL API of the unschedule()\nfunction is updated consistently with the cron.job table definition.","shortMessageHtmlLink":"Select procedure based on argument type of cron_unschedule_named"}},{"before":"be9d040c49b322d5352baeabd234f714c7e3f10b","after":"b618b116c379e324fbba498e3bbfbb801218a0fd","ref":"refs/heads/compat/1.4","pushedAt":"2024-08-09T11:54:02.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"CyberDem0n","name":"Alexander Kukushkin","path":"/CyberDem0n","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/3407345?s=80&v=4"},"commit":{"message":"Select procedure based on argument type of cron_unschedule_named\n\nThe #299 PR took care of bacward compatibility of the function, but\nthere is still one problem left. If extension isn't updated type of the\njobname field in the cron.job table is still NAME, and as a result scan\nwas failing to find rows and unschedule a named job.\n\nThis fix is relying on the fact that SQL API of the unschedule()\nfunction is updated consistently with the cron.job table definition.","shortMessageHtmlLink":"Select procedure based on argument type of cron_unschedule_named"}},{"before":null,"after":"be9d040c49b322d5352baeabd234f714c7e3f10b","ref":"refs/heads/compat/1.4","pushedAt":"2024-08-09T11:52:27.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"CyberDem0n","name":"Alexander Kukushkin","path":"/CyberDem0n","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/3407345?s=80&v=4"},"commit":{"message":"Select procedure based on argument type of cron_unschedule_named\n\nThe #299 PR took care of bacward compatibility of the function, but\nthere is still one problem left. If extension isn't updated type of the\njobname field in the cron.job table is still NAME, and as a result scan\nwas failing to find rows and unschedule a named job.\n\nThis fix is relying on the fact that SQL API of the unschedule()\nfunction is updated consistently with the cron.job table definition.","shortMessageHtmlLink":"Select procedure based on argument type of cron_unschedule_named"}},{"before":"a666e11933233d5d5fc2a6735f655b60e2581b16","after":null,"ref":"refs/heads/bugfix/job-cache-invalidation","pushedAt":"2024-08-09T09:58:38.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"marcoslot","name":"Marco Slot","path":"/marcoslot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/529570?s=80&v=4"}},{"before":"9d0576c64edd90fb3d8ac30763296a8106315638","after":"e5eb77e8634cb41b2b16e71c6320cfe637ec3043","ref":"refs/heads/main","pushedAt":"2024-08-09T09:58:32.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"marcoslot","name":"Marco Slot","path":"/marcoslot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/529570?s=80&v=4"},"commit":{"message":"Merge pull request #346 from citusdata/bugfix/job-cache-invalidation\n\nFix bug with invalidation of CachedCronJobRelationId","shortMessageHtmlLink":"Merge pull request #346 from citusdata/bugfix/job-cache-invalidation"}},{"before":null,"after":"a666e11933233d5d5fc2a6735f655b60e2581b16","ref":"refs/heads/bugfix/job-cache-invalidation","pushedAt":"2024-08-09T08:07:28.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"CyberDem0n","name":"Alexander Kukushkin","path":"/CyberDem0n","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/3407345?s=80&v=4"},"commit":{"message":"Fix bug with invalidation of CachedCronJobRelationId\n\nThe callback was registered only for bgworker and as a result client\nbackends were failing to unschedule jobs if the extension was droped and\nrecreated in the same session:\n```\nCREATE EXTENSION pg_cron;\nSELECT cron.schedule('0 10 * * *', 'VACUUM');\nSELECT cron.unschedule(1);\nDROP EXTENSION pg_cron;\nCREATE EXTENSION pg_cron;\nSELECT cron.schedule('0 10 * * *', 'VACUUM');\nSELECT cron.unschedule(1);\nERROR: could not open relation with OID 16388\n```","shortMessageHtmlLink":"Fix bug with invalidation of CachedCronJobRelationId"}},{"before":"e2a6143b706f8a36a24442c8af99ed1f58704d68","after":"9d0576c64edd90fb3d8ac30763296a8106315638","ref":"refs/heads/main","pushedAt":"2024-06-17T11:25:02.000Z","pushType":"pr_merge","commitsCount":3,"pusher":{"login":"marcoslot","name":"Marco Slot","path":"/marcoslot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/529570?s=80&v=4"},"commit":{"message":"Merge pull request #317 from japinli/illumos\n\nFix compiler error on Illumos","shortMessageHtmlLink":"Merge pull request #317 from japinli/illumos"}},{"before":"a77fb1b4799436db2081a100a4eeaadce5019f73","after":"e2a6143b706f8a36a24442c8af99ed1f58704d68","ref":"refs/heads/main","pushedAt":"2024-05-31T18:59:06.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"marcoslot","name":"Marco Slot","path":"/marcoslot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/529570?s=80&v=4"},"commit":{"message":"Merge pull request #332 from esiaero/main\n\nReplace MemoryContextResetAndDeleteChildren macro with MemoryContextReset for PG 17 compatibility","shortMessageHtmlLink":"Merge pull request #332 from esiaero/main"}},{"before":"d90843de92d5e517a23b1e17da56dc08c496c774","after":"a77fb1b4799436db2081a100a4eeaadce5019f73","ref":"refs/heads/main","pushedAt":"2024-05-28T13:32:10.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"marcoslot","name":"Marco Slot","path":"/marcoslot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/529570?s=80&v=4"},"commit":{"message":"Merge pull request #331 from ryw/patch-1\n\nMake it easier to find the query to see all scheduled jobs","shortMessageHtmlLink":"Merge pull request #331 from ryw/patch-1"}},{"before":"9a5324dfee6a961d3dc21b95737385c22c3ed57a","after":"d90843de92d5e517a23b1e17da56dc08c496c774","ref":"refs/heads/main","pushedAt":"2024-05-17T08:36:24.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"marcoslot","name":"Marco Slot","path":"/marcoslot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/529570?s=80&v=4"},"commit":{"message":"Remove unnecessary lastStartTime reset","shortMessageHtmlLink":"Remove unnecessary lastStartTime reset"}},{"before":"e7996b66ab64b4cce97431bc2e54225c47215ca4","after":"9a5324dfee6a961d3dc21b95737385c22c3ed57a","ref":"refs/heads/main","pushedAt":"2024-05-17T08:30:52.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"marcoslot","name":"Marco Slot","path":"/marcoslot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/529570?s=80&v=4"},"commit":{"message":"Merge pull request #324 from kketch/kketch/start-time-for-all-failed-runs\n\nLog start & end time for all failed runs","shortMessageHtmlLink":"Merge pull request #324 from kketch/kketch/start-time-for-all-failed-…"}},{"before":"7e91e72b1bebc5869bb900d9253cc9e92518b33f","after":"e7996b66ab64b4cce97431bc2e54225c47215ca4","ref":"refs/heads/main","pushedAt":"2024-05-17T08:22:45.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"marcoslot","name":"Marco Slot","path":"/marcoslot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/529570?s=80&v=4"},"commit":{"message":"Merge pull request #326 from sminux/fix_unget_data_overflow\n\nFixes #311","shortMessageHtmlLink":"Merge pull request #326 from sminux/fix_unget_data_overflow"}},{"before":"2a1d3113f58306870fd9aa970e61e54284795917","after":"7e91e72b1bebc5869bb900d9253cc9e92518b33f","ref":"refs/heads/main","pushedAt":"2024-04-05T14:55:15.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"marcoslot","name":"Marco Slot","path":"/marcoslot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/529570?s=80&v=4"},"commit":{"message":"Merge pull request #319 from Ngalstyan4/narek/fix-drop-database-deadlock\n\nAllow interrupts in pg_cron launcher loop to avoid deadlock","shortMessageHtmlLink":"Merge pull request #319 from Ngalstyan4/narek/fix-drop-database-deadlock"}},{"before":"d6f841cc9bfe98f4ee902acb0a329aef45617dca","after":"2a1d3113f58306870fd9aa970e61e54284795917","ref":"refs/heads/main","pushedAt":"2024-02-06T21:06:59.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"marcoslot","name":"Marco Slot","path":"/marcoslot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/529570?s=80&v=4"},"commit":{"message":"Merge pull request #310 from ryw/main\n\nAdd Tembo to list of managed clouds","shortMessageHtmlLink":"Merge pull request #310 from ryw/main"}},{"before":"a8cb0e0b5018cf82e5a90728a91d04fb79594642","after":"d6f841cc9bfe98f4ee902acb0a329aef45617dca","ref":"refs/heads/main","pushedAt":"2024-01-05T22:51:07.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"marcoslot","name":"Marco Slot","path":"/marcoslot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/529570?s=80&v=4"},"commit":{"message":"Merge pull request #299 from nmisch/compat1.4\n\nMake cron_unschedule_named() accept v1.4 SQL signature.","shortMessageHtmlLink":"Merge pull request #299 from nmisch/compat1.4"}},{"before":"cd13bc99ca4587a225e8d4472c28df2e9bdbcb93","after":"a8cb0e0b5018cf82e5a90728a91d04fb79594642","ref":"refs/heads/main","pushedAt":"2023-11-04T14:09:48.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"marcoslot","name":"Marco Slot","path":"/marcoslot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/529570?s=80&v=4"},"commit":{"message":"Merge pull request #293 from nuno-faria/main","shortMessageHtmlLink":"Merge pull request #293 from nuno-faria/main"}},{"before":"306a680d5a447d8ef710e846fbeac3ad9757579a","after":"cd13bc99ca4587a225e8d4472c28df2e9bdbcb93","ref":"refs/heads/main","pushedAt":"2023-10-20T22:07:12.000Z","pushType":"pr_merge","commitsCount":3,"pusher":{"login":"marcoslot","name":"Marco Slot","path":"/marcoslot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/529570?s=80&v=4"},"commit":{"message":"Merge pull request #292 from citusdata/marcoslot/fix-dom","shortMessageHtmlLink":"Merge pull request #292 from citusdata/marcoslot/fix-dom"}},{"before":"c9dedd3947d80566b6418c0fb2e30f10191d3dca","after":"be3876deead213dc33db87c7fad4f72345f14c81","ref":"refs/heads/marcoslot/fix-dom","pushedAt":"2023-10-20T22:02:25.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"marcoslot","name":"Marco Slot","path":"/marcoslot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/529570?s=80&v=4"},"commit":{"message":"Update CHANGELOG.md","shortMessageHtmlLink":"Update CHANGELOG.md"}},{"before":null,"after":"c9dedd3947d80566b6418c0fb2e30f10191d3dca","ref":"refs/heads/marcoslot/fix-dom","pushedAt":"2023-10-20T21:59:56.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"marcoslot","name":"Marco Slot","path":"/marcoslot","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/529570?s=80&v=4"},"commit":{"message":"Fix pointer reuse bug causing off-by-1 day of month","shortMessageHtmlLink":"Fix pointer reuse bug causing off-by-1 day of month"}},{"before":"35c67f11039abf5832a1ec40a2c903b2fd4f35ba","after":null,"ref":"refs/heads/qualify-func-call","pushedAt":"2023-10-16T11:40:34.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"hanefi","name":"Hanefi Onaldi","path":"/hanefi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6772247?s=80&v=4"}},{"before":"fa978887b0277ccd22ef5332ebf3876780b64d5f","after":"306a680d5a447d8ef710e846fbeac3ad9757579a","ref":"refs/heads/main","pushedAt":"2023-10-16T11:40:26.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"hanefi","name":"Hanefi Onaldi","path":"/hanefi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6772247?s=80&v=4"},"commit":{"message":"Qualify function call in migration script (#291)\n\nThe migration script for pg_cron 1.2 to 1.3 was using nextval() without\r\nqualifying it with pg_catalog. This is a problem if the user has\r\ninstalled pg_cron in a schema other than pg_catalog. This commit fixes\r\nthe problem by qualifying the function call.","shortMessageHtmlLink":"Qualify function call in migration script (#291)"}},{"before":"e88d3887a4630df84480718206f25ab5c235c8a5","after":"35c67f11039abf5832a1ec40a2c903b2fd4f35ba","ref":"refs/heads/qualify-func-call","pushedAt":"2023-10-16T11:26:38.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"hanefi","name":"Hanefi Onaldi","path":"/hanefi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6772247?s=80&v=4"},"commit":{"message":"Qualify function call in migration script\n\nThe migration script for pg_cron 1.2 to 1.3 was using nextval() without\nqualifying it with pg_catalog. This is a problem if the user has\ninstalled pg_cron in a schema other than pg_catalog. This commit fixes\nthe problem by qualifying the function call.","shortMessageHtmlLink":"Qualify function call in migration script"}},{"before":null,"after":"e88d3887a4630df84480718206f25ab5c235c8a5","ref":"refs/heads/qualify-func-call","pushedAt":"2023-10-16T11:25:57.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"hanefi","name":"Hanefi Onaldi","path":"/hanefi","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/6772247?s=80&v=4"},"commit":{"message":"Qualify function call in migraion script\n\nThe migration script for pg_cron 1.2 to 1.3 was using nextval() without\nqualifying it with pg_catalog. This is a problem if the user has\ninstalled pg_cron in a schema other than pg_catalog. This commit fixes\nthe problem by qualifying the function call.","shortMessageHtmlLink":"Qualify function call in migraion script"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEoXBRBgA","startCursor":null,"endCursor":null}},"title":"Activity · citusdata/pg_cron"}