supabase-postgres.git / summary / log / commit / refs
commit 7161e98523212438d56dbd92e51b620e7fbbfd39
Author: Artur Zakirov <zaartur@gmail.com>
Commit: GitHub <noreply@github.com>
Date: Wed Jul 15 20:04:26 2026 +0000
feat: update orioledb to beta16 (#2232)
ansible/vars.yml | 6 +++---
migrations/schema-orioledb-17.sql | 4 ++--
nix/config.nix | 4 ++--
nix/ext/orioledb.nix | 8 ++++----
...multigres-orioledb-17_docs-cascades-deletes.out | 24 +++++++++++-----------
.../z_multigres-orioledb-17_docs-functions.out | 2 +-
.../z_multigres-orioledb-17_ext_interface.out | 8 +++++++-
.../z_orioledb-17_docs-cascades-deletes.out | 24 +++++++++++-----------
.../expected/z_orioledb-17_docs-functions.out | 2 +-
nix/tests/expected/z_orioledb-17_ext_interface.out | 8 +++++++-
10 files changed, 51 insertions(+), 39 deletions(-)
diff --git a/ansible/vars.yml b/ansible/vars.yml
index 2d4b3f46..4ba1b7c3 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.104-orioledb"
- postgres17: "17.6.1.147"
- postgres15: "15.14.1.147"
+ postgresorioledb-17: "17.9.0.001-orioledb"
+ postgres17: "17.6.1.148"
+ postgres15: "15.14.1.148"
# Non Postgres Extensions
pgbouncer_release: 1.25.1
diff --git a/migrations/schema-orioledb-17.sql b/migrations/schema-orioledb-17.sql
index cf4bc3ca..48319e20 100644
--- a/migrations/schema-orioledb-17.sql
+++ b/migrations/schema-orioledb-17.sql
@@ -4,8 +4,8 @@
\restrict SupabaseTestDumpKey123
--- Dumped from database version 17.6
--- Dumped by pg_dump version 17.6
+-- Dumped from database version 17.9
+-- Dumped by pg_dump version 17.9
SET statement_timeout = 0;
SET lock_timeout = 0;
diff --git a/nix/config.nix b/nix/config.nix
index e6168367..7ed5338e 100644
--- a/nix/config.nix
+++ b/nix/config.nix
@@ -56,8 +56,8 @@ in
};
orioledb = {
"17" = {
- version = "17_16";
- hash = "sha256-Xm9IUsvmlcayNQH8TCvHoIV23xkt/WQV0Oy4CiJkywc=";
+ version = "17_20";
+ hash = "sha256-HDrHTx9yeIPJoyIBs+BdAhBQqt1IEtQrG9pFfvHJqdg=";
};
};
};
diff --git a/nix/ext/orioledb.nix b/nix/ext/orioledb.nix
index e338a3a2..0a9a5465 100644
--- a/nix/ext/orioledb.nix
+++ b/nix/ext/orioledb.nix
@@ -15,10 +15,10 @@ stdenv.mkDerivation rec {
src = fetchFromGitHub {
owner = "orioledb";
repo = "orioledb";
- rev = "982e11ae62c9e00c0d74f9f8de31d99ff383fd02";
- sha256 = "sha256-Vz3vfmTGRW+O9aXZxqixHC2CpqZJf/1UCQWoENbAak4=";
+ rev = "beta16";
+ sha256 = "sha256-HCfNzMPt80nGeVwlstUCeMpdNZYd9KhLLHYyD/Hvuhk=";
};
- version = "982e11ae62c9e00c0d74f9f8de31d99ff383fd02";
+ version = "beta16";
buildInputs = [
curl
libkrb5
@@ -27,7 +27,7 @@ stdenv.mkDerivation rec {
openssl
];
buildPhase = ''
- make USE_PGXS=1 ORIOLEDB_PATCHSET_VERSION=16
+ make USE_PGXS=1 ORIOLEDB_PATCHSET_VERSION=20
'';
installPhase = ''
runHook preInstall
diff --git a/nix/tests/expected/z_multigres-orioledb-17_docs-cascades-deletes.out b/nix/tests/expected/z_multigres-orioledb-17_docs-cascades-deletes.out
index e196992d..1f5d5f77 100644
--- a/nix/tests/expected/z_multigres-orioledb-17_docs-cascades-deletes.out
+++ b/nix/tests/expected/z_multigres-orioledb-17_docs-cascades-deletes.out
@@ -76,25 +76,25 @@ insert into grandparent
values
(1, 'Elizabeth');
ERROR: duplicate key value violates unique constraint "grandparent_pkey"
-DETAIL: Key (id)=('1') already exists.
+DETAIL: Key (id)=(1) already exists.
insert into parent
(id, name, parent_id)
values
(1, 'Charles', 1);
ERROR: duplicate key value violates unique constraint "parent_pkey"
-DETAIL: Key (id)=('1') already exists.
+DETAIL: Key (id)=(1) already exists.
insert into parent
(id, name, parent_id)
values
(2, 'Diana', 1);
ERROR: duplicate key value violates unique constraint "parent_pkey"
-DETAIL: Key (id)=('2') already exists.
+DETAIL: Key (id)=(2) already exists.
insert into child
(id, name, father)
values
(1, 'William', 1);
ERROR: duplicate key value violates unique constraint "child_pkey"
-DETAIL: Key (id)=('1') already exists.
+DETAIL: Key (id)=(1) already exists.
alter table child
drop constraint child_father_fkey;
alter table child
@@ -126,25 +126,25 @@ insert into grandparent
values
(1, 'Elizabeth');
ERROR: duplicate key value violates unique constraint "grandparent_pkey"
-DETAIL: Key (id)=('1') already exists.
+DETAIL: Key (id)=(1) already exists.
insert into parent
(id, name, parent_id)
values
(1, 'Charles', 1);
ERROR: duplicate key value violates unique constraint "parent_pkey"
-DETAIL: Key (id)=('1') already exists.
+DETAIL: Key (id)=(1) already exists.
insert into parent
(id, name, parent_id)
values
(2, 'Diana', 1);
ERROR: duplicate key value violates unique constraint "parent_pkey"
-DETAIL: Key (id)=('2') already exists.
+DETAIL: Key (id)=(2) already exists.
insert into child
(id, name, father)
values
(1, 'William', 1);
ERROR: duplicate key value violates unique constraint "child_pkey"
-DETAIL: Key (id)=('1') already exists.
+DETAIL: Key (id)=(1) already exists.
alter table child
drop constraint child_father_fkey;
alter table child
@@ -176,25 +176,25 @@ insert into grandparent
values
(1, 'Elizabeth');
ERROR: duplicate key value violates unique constraint "grandparent_pkey"
-DETAIL: Key (id)=('1') already exists.
+DETAIL: Key (id)=(1) already exists.
insert into parent
(id, name, parent_id)
values
(1, 'Charles', 1);
ERROR: duplicate key value violates unique constraint "parent_pkey"
-DETAIL: Key (id)=('1') already exists.
+DETAIL: Key (id)=(1) already exists.
insert into parent
(id, name, parent_id)
values
(2, 'Diana', 1);
ERROR: duplicate key value violates unique constraint "parent_pkey"
-DETAIL: Key (id)=('2') already exists.
+DETAIL: Key (id)=(2) already exists.
insert into child
(id, name, father)
values
(1, 'William', 1);
ERROR: duplicate key value violates unique constraint "child_pkey"
-DETAIL: Key (id)=('1') already exists.
+DETAIL: Key (id)=(1) already exists.
alter table child
add column mother integer references parent (id)
on delete cascade;
diff --git a/nix/tests/expected/z_multigres-orioledb-17_docs-functions.out b/nix/tests/expected/z_multigres-orioledb-17_docs-functions.out
index e18694e0..9acc45ff 100644
--- a/nix/tests/expected/z_multigres-orioledb-17_docs-functions.out
+++ b/nix/tests/expected/z_multigres-orioledb-17_docs-functions.out
@@ -63,7 +63,7 @@ end;
$$;
select * from add_planet('Jakku');
ERROR: duplicate key value violates unique constraint "planets_pkey"
-DETAIL: Key (id)=('1') already exists.
+DETAIL: Key (id)=(1) already exists.
CONTEXT: SQL statement "insert into planets(name)
values (add_planet.name)
returning id"
diff --git a/nix/tests/expected/z_multigres-orioledb-17_ext_interface.out b/nix/tests/expected/z_multigres-orioledb-17_ext_interface.out
index f7b4ce6d..c6d7b861 100644
--- a/nix/tests/expected/z_multigres-orioledb-17_ext_interface.out
+++ b/nix/tests/expected/z_multigres-orioledb-17_ext_interface.out
@@ -1096,10 +1096,14 @@ order by
orioledb | extensions | orioledb_index_oids | OUT datoid oid, OUT table_reloid oid, OUT table_relnode oid, OUT index_reloid oid, OUT index_relnode oid, OUT index_type text | SETOF record
orioledb | extensions | orioledb_index_rows | relid oid, OUT total integer, OUT dead integer | record
orioledb | extensions | orioledb_page_stats | OUT pool_name text, OUT busy_pages bigint, OUT free_pages bigint, OUT dirty_pages bigint, OUT all_pages bigint | SETOF record
+ orioledb | extensions | orioledb_print_pool_pages | ppool_arg integer, OUT block_num bigint, OUT name text, OUT datoid bigint, OUT reloid bigint, OUT relnode bigint, OUT type text, OUT state bigint | SETOF record
orioledb | extensions | orioledb_recovery_synchronized | | boolean
orioledb | extensions | orioledb_relation_size | relid oid | bigint
+ orioledb | extensions | orioledb_rewind_by_time | rewind_time integer, attempt_restart boolean | void
orioledb | extensions | orioledb_rewind_by_time | rewind_time integer | void
+ orioledb | extensions | orioledb_rewind_to_timestamp | rewind_timestamp timestamp with time zone, attempt_restart boolean | void
orioledb | extensions | orioledb_rewind_to_timestamp | rewind_timestamp timestamp with time zone | void
+ orioledb | extensions | orioledb_rewind_to_transaction | xid integer, oxid bigint, attempt_restart boolean | void
orioledb | extensions | orioledb_rewind_to_transaction | xid integer, oxid bigint | void
orioledb | extensions | orioledb_sys_tree_check | num integer, force_map_check boolean | boolean
orioledb | extensions | orioledb_sys_tree_rows | num integer | SETOF jsonb
@@ -1118,12 +1122,14 @@ order by
orioledb | extensions | orioledb_tbl_structure | relid oid, options character varying, depth integer | text
orioledb | extensions | orioledb_tree_stat | relid regclass, OUT level integer, OUT count bigint, OUT avgoccupied double precision, OUT avgvacated double precision | SETOF record
orioledb | extensions | orioledb_ucm_check | | boolean
+ orioledb | extensions | orioledb_undo_size | OUT undo_type text, OUT undo_size bigint | SETOF record
orioledb | extensions | orioledb_version | | text
orioledb | extensions | orioledb_write_pages | relid oid | void
orioledb | extensions | pg_stopevent_reset | eventname text | boolean
orioledb | extensions | pg_stopevent_set | eventname text, condition jsonpath, flags text | void
orioledb | extensions | pg_stopevent_set | eventname text, condition jsonpath | void
orioledb | extensions | pg_stopevents | OUT stopevent text, OUT condition jsonpath, OUT waiter_pids integer[] | SETOF record
+ orioledb | extensions | verify_orioledb | relation regclass, thorough_check boolean, OUT index_name text, OUT msg text | SETOF record
pageinspect | public | brin_metapage_info | page bytea, OUT magic text, OUT version integer, OUT pagesperrange integer, OUT lastrevmappage bigint | record
pageinspect | public | brin_page_type | page bytea | text
pageinspect | public | brin_revmap_data | page bytea, OUT pages tid | SETOF tid
@@ -4860,7 +4866,7 @@ order by
xml2 | public | xpath_table | text, text, text, text, text | SETOF record
xml2 | public | xslt_process | text, text | text
xml2 | public | xslt_process | text, text, text | text
-(4700 rows)
+(4706 rows)
/*
diff --git a/nix/tests/expected/z_orioledb-17_docs-cascades-deletes.out b/nix/tests/expected/z_orioledb-17_docs-cascades-deletes.out
index e196992d..1f5d5f77 100644
--- a/nix/tests/expected/z_orioledb-17_docs-cascades-deletes.out
+++ b/nix/tests/expected/z_orioledb-17_docs-cascades-deletes.out
@@ -76,25 +76,25 @@ insert into grandparent
values
(1, 'Elizabeth');
ERROR: duplicate key value violates unique constraint "grandparent_pkey"
-DETAIL: Key (id)=('1') already exists.
+DETAIL: Key (id)=(1) already exists.
insert into parent
(id, name, parent_id)
values
(1, 'Charles', 1);
ERROR: duplicate key value violates unique constraint "parent_pkey"
-DETAIL: Key (id)=('1') already exists.
+DETAIL: Key (id)=(1) already exists.
insert into parent
(id, name, parent_id)
values
(2, 'Diana', 1);
ERROR: duplicate key value violates unique constraint "parent_pkey"
-DETAIL: Key (id)=('2') already exists.
+DETAIL: Key (id)=(2) already exists.
insert into child
(id, name, father)
values
(1, 'William', 1);
ERROR: duplicate key value violates unique constraint "child_pkey"
-DETAIL: Key (id)=('1') already exists.
+DETAIL: Key (id)=(1) already exists.
alter table child
drop constraint child_father_fkey;
alter table child
@@ -126,25 +126,25 @@ insert into grandparent
values
(1, 'Elizabeth');
ERROR: duplicate key value violates unique constraint "grandparent_pkey"
-DETAIL: Key (id)=('1') already exists.
+DETAIL: Key (id)=(1) already exists.
insert into parent
(id, name, parent_id)
values
(1, 'Charles', 1);
ERROR: duplicate key value violates unique constraint "parent_pkey"
-DETAIL: Key (id)=('1') already exists.
+DETAIL: Key (id)=(1) already exists.
insert into parent
(id, name, parent_id)
values
(2, 'Diana', 1);
ERROR: duplicate key value violates unique constraint "parent_pkey"
-DETAIL: Key (id)=('2') already exists.
+DETAIL: Key (id)=(2) already exists.
insert into child
(id, name, father)
values
(1, 'William', 1);
ERROR: duplicate key value violates unique constraint "child_pkey"
-DETAIL: Key (id)=('1') already exists.
+DETAIL: Key (id)=(1) already exists.
alter table child
drop constraint child_father_fkey;
alter table child
@@ -176,25 +176,25 @@ insert into grandparent
values
(1, 'Elizabeth');
ERROR: duplicate key value violates unique constraint "grandparent_pkey"
-DETAIL: Key (id)=('1') already exists.
+DETAIL: Key (id)=(1) already exists.
insert into parent
(id, name, parent_id)
values
(1, 'Charles', 1);
ERROR: duplicate key value violates unique constraint "parent_pkey"
-DETAIL: Key (id)=('1') already exists.
+DETAIL: Key (id)=(1) already exists.
insert into parent
(id, name, parent_id)
values
(2, 'Diana', 1);
ERROR: duplicate key value violates unique constraint "parent_pkey"
-DETAIL: Key (id)=('2') already exists.
+DETAIL: Key (id)=(2) already exists.
insert into child
(id, name, father)
values
(1, 'William', 1);
ERROR: duplicate key value violates unique constraint "child_pkey"
-DETAIL: Key (id)=('1') already exists.
+DETAIL: Key (id)=(1) already exists.
alter table child
add column mother integer references parent (id)
on delete cascade;
diff --git a/nix/tests/expected/z_orioledb-17_docs-functions.out b/nix/tests/expected/z_orioledb-17_docs-functions.out
index e18694e0..9acc45ff 100644
--- a/nix/tests/expected/z_orioledb-17_docs-functions.out
+++ b/nix/tests/expected/z_orioledb-17_docs-functions.out
@@ -63,7 +63,7 @@ end;
$$;
select * from add_planet('Jakku');
ERROR: duplicate key value violates unique constraint "planets_pkey"
-DETAIL: Key (id)=('1') already exists.
+DETAIL: Key (id)=(1) already exists.
CONTEXT: SQL statement "insert into planets(name)
values (add_planet.name)
returning id"
diff --git a/nix/tests/expected/z_orioledb-17_ext_interface.out b/nix/tests/expected/z_orioledb-17_ext_interface.out
index 732dc170..0718c6ed 100644
--- a/nix/tests/expected/z_orioledb-17_ext_interface.out
+++ b/nix/tests/expected/z_orioledb-17_ext_interface.out
@@ -1096,10 +1096,14 @@ order by
orioledb | extensions | orioledb_index_oids | OUT datoid oid, OUT table_reloid oid, OUT table_relnode oid, OUT index_reloid oid, OUT index_relnode oid, OUT index_type text | SETOF record
orioledb | extensions | orioledb_index_rows | relid oid, OUT total integer, OUT dead integer | record
orioledb | extensions | orioledb_page_stats | OUT pool_name text, OUT busy_pages bigint, OUT free_pages bigint, OUT dirty_pages bigint, OUT all_pages bigint | SETOF record
+ orioledb | extensions | orioledb_print_pool_pages | ppool_arg integer, OUT block_num bigint, OUT name text, OUT datoid bigint, OUT reloid bigint, OUT relnode bigint, OUT type text, OUT state bigint | SETOF record
orioledb | extensions | orioledb_recovery_synchronized | | boolean
orioledb | extensions | orioledb_relation_size | relid oid | bigint
+ orioledb | extensions | orioledb_rewind_by_time | rewind_time integer, attempt_restart boolean | void
orioledb | extensions | orioledb_rewind_by_time | rewind_time integer | void
+ orioledb | extensions | orioledb_rewind_to_timestamp | rewind_timestamp timestamp with time zone, attempt_restart boolean | void
orioledb | extensions | orioledb_rewind_to_timestamp | rewind_timestamp timestamp with time zone | void
+ orioledb | extensions | orioledb_rewind_to_transaction | xid integer, oxid bigint, attempt_restart boolean | void
orioledb | extensions | orioledb_rewind_to_transaction | xid integer, oxid bigint | void
orioledb | extensions | orioledb_sys_tree_check | num integer, force_map_check boolean | boolean
orioledb | extensions | orioledb_sys_tree_rows | num integer | SETOF jsonb
@@ -1118,12 +1122,14 @@ order by
orioledb | extensions | orioledb_tbl_structure | relid oid, options character varying, depth integer | text
orioledb | extensions | orioledb_tree_stat | relid regclass, OUT level integer, OUT count bigint, OUT avgoccupied double precision, OUT avgvacated double precision | SETOF record
orioledb | extensions | orioledb_ucm_check | | boolean
+ orioledb | extensions | orioledb_undo_size | OUT undo_type text, OUT undo_size bigint | SETOF record
orioledb | extensions | orioledb_version | | text
orioledb | extensions | orioledb_write_pages | relid oid | void
orioledb | extensions | pg_stopevent_reset | eventname text | boolean
orioledb | extensions | pg_stopevent_set | eventname text, condition jsonpath, flags text | void
orioledb | extensions | pg_stopevent_set | eventname text, condition jsonpath | void
orioledb | extensions | pg_stopevents | OUT stopevent text, OUT condition jsonpath, OUT waiter_pids integer[] | SETOF record
+ orioledb | extensions | verify_orioledb | relation regclass, thorough_check boolean, OUT index_name text, OUT msg text | SETOF record
pageinspect | public | brin_metapage_info | page bytea, OUT magic text, OUT version integer, OUT pagesperrange integer, OUT lastrevmappage bigint | record
pageinspect | public | brin_page_type | page bytea | text
pageinspect | public | brin_revmap_data | page bytea, OUT pages tid | SETOF tid
@@ -4997,7 +5003,7 @@ order by
xml2 | public | xpath_table | text, text, text, text, text | SETOF record
xml2 | public | xslt_process | text, text | text
xml2 | public | xslt_process | text, text, text | text
-(4837 rows)
+(4843 rows)
/*
[parent: 098d237ff5b2]