supabase-postgres.git / summary / log / commit / refs

commit    7bb86cb00a2c552bd84e00ed6dd8db32a0da4c9a
Author:   Artur Zakirov <zaartur@gmail.com>
Commit:   GitHub <noreply@github.com>
Date:     Mon Jul 06 19:57:13 2026 +0000

    feat: add USING heap to pg_cron installation script (#2242)


 ansible/vars.yml                          |  6 +++---
 nix/ext/pg_cron/pg_cron-heap-tables.patch | 26 ++++++++++++++++++++++++++
 nix/ext/versions.json                     |  5 ++++-
 3 files changed, 33 insertions(+), 4 deletions(-)

diff --git a/ansible/vars.yml b/ansible/vars.yml
index c0ab29ef..4db5397b 100644
--- a/ansible/vars.yml
+++ b/ansible/vars.yml
@@ -10,9 +10,9 @@ postgres_major:
 
 # Full version strings for each major version
 postgres_release:
-  postgresorioledb-17: "17.6.0.099-orioledb"
-  postgres17: "17.6.1.142"
-  postgres15: "15.14.1.142"
+  postgresorioledb-17: "17.6.0.100-orioledb"
+  postgres17: "17.6.1.143"
+  postgres15: "15.14.1.143"
 
 # Non Postgres Extensions
 pgbouncer_release: 1.25.1
diff --git a/nix/ext/pg_cron/pg_cron-heap-tables.patch b/nix/ext/pg_cron/pg_cron-heap-tables.patch
new file mode 100644
index 00000000..065b58a4
--- /dev/null
+++ b/nix/ext/pg_cron/pg_cron-heap-tables.patch
@@ -0,0 +1,26 @@
+diff --git a/pg_cron--1.2--1.3.sql b/pg_cron--1.2--1.3.sql
+index b1e6a68..f4b94e7 100644
+--- a/pg_cron--1.2--1.3.sql
++++ b/pg_cron--1.2--1.3.sql
+@@ -12,7 +12,7 @@ CREATE TABLE cron.job_run_details (
+ 	return_message text,
+ 	start_time timestamptz,
+ 	end_time timestamptz
+-);
++) USING heap;
+ 
+ GRANT SELECT ON cron.job_run_details TO public;
+ GRANT DELETE ON cron.job_run_details TO public;
+diff --git a/pg_cron.sql b/pg_cron.sql
+index 2de23f4..e843ac7 100644
+--- a/pg_cron.sql
++++ b/pg_cron.sql
+@@ -23,7 +23,7 @@ CREATE TABLE cron.job (
+ 	nodeport int not null default pg_catalog.inet_server_port(),
+ 	database text not null default pg_catalog.current_database(),
+ 	username text not null default current_user
+-);
++) USING heap;
+ GRANT SELECT ON cron.job TO public;
+ ALTER TABLE cron.job ENABLE ROW LEVEL SECURITY;
+ CREATE POLICY cron_job_policy ON cron.job USING (username OPERATOR(pg_catalog.=) current_user);
diff --git a/nix/ext/versions.json b/nix/ext/versions.json
index 8fc058b1..d9ac882b 100644
--- a/nix/ext/versions.json
+++ b/nix/ext/versions.json
@@ -114,7 +114,10 @@
         "orioledb-17"
       ],
       "rev": "v1.6.4",
-      "hash": "sha256-t1DpFkPiSfdoGG2NgNT7g1lkvSooZoRoUrix6cBID40="
+      "hash": "sha256-t1DpFkPiSfdoGG2NgNT7g1lkvSooZoRoUrix6cBID40=",
+      "patches": [
+        "pg_cron-heap-tables.patch"
+      ]
     }
   },
   "pg_graphql": {