Update 2024-11 changelog

BemiHQ · Dec 11, 2024 · 10a37f4 · 10a37f4
1 parent d66df6c
commit 10a37f4
Show file tree

Hide file tree

Showing 5 changed files with 6 additions and 4 deletions.
diff --git a/docs/docs/changelog.md b/docs/docs/changelog.md
@@ -11,6 +11,8 @@ keywords: ['Bemi Changelog', 'Bemi New Features', 'Postgres Audit Trails', 'Chan
 
 ## 2024-11
 
+* [Bemi Django](https://github.com/BemiHQ/bemi-django)
+  * Add functionality for querying, filtering, and sorting changes
 * [Bemi Prisma](https://github.com/BemiHQ/bemi-prisma)
   * Allow using Prisma client database URL specified in `datasources.db`
 

diff --git a/docs/docs/hosting/aws.md b/docs/docs/hosting/aws.md
@@ -76,7 +76,7 @@ CREATE PUBLICATION bemi FOR ALL TABLES;
 -- Create a procedure to set REPLICA IDENTITY FULL for tables to track the "before" state on DB row changes
 CREATE OR REPLACE PROCEDURE _bemi_set_replica_identity() AS $$ DECLARE current_tablename TEXT;
 BEGIN
-  FOR current_tablename IN SELECT tablename FROM pg_tables LEFT JOIN pg_class ON relname = tablename WHERE schemaname = 'public' AND relreplident != 'f' LOOP
+  FOR current_tablename IN SELECT tablename FROM pg_tables LEFT JOIN pg_class ON relname = tablename WHERE schemaname = 'public' AND relkind != 'f' AND relreplident != 'f' LOOP
     EXECUTE format('ALTER TABLE %I REPLICA IDENTITY FULL', current_tablename);
   END LOOP;
 END $$ LANGUAGE plpgsql;

diff --git a/docs/docs/hosting/gcp.md b/docs/docs/hosting/gcp.md
@@ -44,7 +44,7 @@ CREATE PUBLICATION bemi FOR ALL TABLES;
 -- Create a procedure to set REPLICA IDENTITY FULL for tables to track the "before" state on DB row changes
 CREATE OR REPLACE PROCEDURE _bemi_set_replica_identity() AS $$ DECLARE current_tablename TEXT;
 BEGIN
-  FOR current_tablename IN SELECT tablename FROM pg_tables LEFT JOIN pg_class ON relname = tablename WHERE schemaname = 'public' AND relreplident != 'f' LOOP
+  FOR current_tablename IN SELECT tablename FROM pg_tables LEFT JOIN pg_class ON relname = tablename WHERE schemaname = 'public' AND relkind != 'f' AND relreplident != 'f' LOOP
     EXECUTE format('ALTER TABLE %I REPLICA IDENTITY FULL', current_tablename);
   END LOOP;
 END $$ LANGUAGE plpgsql;

diff --git a/docs/docs/hosting/neon.md b/docs/docs/hosting/neon.md
@@ -53,7 +53,7 @@ CREATE PUBLICATION bemi FOR ALL TABLES;
 -- Create a procedure to set REPLICA IDENTITY FULL for tables to track the "before" state on DB row changes
 CREATE OR REPLACE PROCEDURE _bemi_set_replica_identity() AS $$ DECLARE current_tablename TEXT;
 BEGIN
-  FOR current_tablename IN SELECT tablename FROM pg_tables LEFT JOIN pg_class ON relname = tablename WHERE schemaname = 'public' AND relreplident != 'f' LOOP
+  FOR current_tablename IN SELECT tablename FROM pg_tables LEFT JOIN pg_class ON relname = tablename WHERE schemaname = 'public' AND relkind != 'f' AND relreplident != 'f' LOOP
     EXECUTE format('ALTER TABLE %I REPLICA IDENTITY FULL', current_tablename);
   END LOOP;
 END $$ LANGUAGE plpgsql;

diff --git a/docs/docs/hosting/self-managed.md b/docs/docs/hosting/self-managed.md
@@ -47,7 +47,7 @@ CREATE PUBLICATION bemi FOR ALL TABLES;
 -- Create a procedure to set REPLICA IDENTITY FULL for tables to track the "before" state on DB row changes
 CREATE OR REPLACE PROCEDURE _bemi_set_replica_identity() AS $$ DECLARE current_tablename TEXT;
 BEGIN
-  FOR current_tablename IN SELECT tablename FROM pg_tables LEFT JOIN pg_class ON relname = tablename WHERE schemaname = 'public' AND relreplident != 'f' LOOP
+  FOR current_tablename IN SELECT tablename FROM pg_tables LEFT JOIN pg_class ON relname = tablename WHERE schemaname = 'public' AND relkind != 'f' AND relreplident != 'f' LOOP
     EXECUTE format('ALTER TABLE %I REPLICA IDENTITY FULL', current_tablename);
   END LOOP;
 END $$ LANGUAGE plpgsql;