commit 8a7f0be2513e2aa4b2caf3d9833f4e2707f0001d
author Emmanuel Allison <emmanuelallison@outlook.com> Fri Mar 22 01:12:08 2024 +0100
committer GitHub <noreply@github.com> Thu Mar 21 17:12:08 2024 -0700
tree 78dd428f7ad9c477b52cb966f68e25334f16f874
parent f557486e99bec8df7d1581d8e27a0a57374b301d

Fix Metadata Load Error in PG v13, v14 and v15 (#154)

* add: meta_data.sql for PostgreSQL 13

* add: meta_data.sql for PG14 nd PG15

backend/sql/13/meta_data.sql

diff --git a/backend/sql/13/meta_data.sql b/backend/sql/13/meta_data.sql
new file mode 100644
index 0000000..8959d54
--- /dev/null
+++ b/backend/sql/13/meta_data.sql
@@ -0,0 +1,13 @@
+SELECT * FROM (
+        SELECT c.relname AS label, n.oid as namespace_id, c.reltuples AS cnt
+        FROM pg_catalog.pg_class c
+        JOIN pg_catalog.pg_namespace n
+        ON n.oid = c.relnamespace
+        WHERE c.relkind = 'r'
+        AND n.nspname = '%s'
+) as q1
+JOIN ag_graph as g ON q1.namespace_id = g.namespace
+INNER JOIN ag_label as label
+
+ON label.name = q1.label
+AND label.graph = g.graphid;

backend/sql/14/meta_data.sql

diff --git a/backend/sql/14/meta_data.sql b/backend/sql/14/meta_data.sql
new file mode 100644
index 0000000..8959d54
--- /dev/null
+++ b/backend/sql/14/meta_data.sql
@@ -0,0 +1,13 @@
+SELECT * FROM (
+        SELECT c.relname AS label, n.oid as namespace_id, c.reltuples AS cnt
+        FROM pg_catalog.pg_class c
+        JOIN pg_catalog.pg_namespace n
+        ON n.oid = c.relnamespace
+        WHERE c.relkind = 'r'
+        AND n.nspname = '%s'
+) as q1
+JOIN ag_graph as g ON q1.namespace_id = g.namespace
+INNER JOIN ag_label as label
+
+ON label.name = q1.label
+AND label.graph = g.graphid;

backend/sql/15/meta_data.sql

diff --git a/backend/sql/15/meta_data.sql b/backend/sql/15/meta_data.sql
new file mode 100644
index 0000000..8959d54
--- /dev/null
+++ b/backend/sql/15/meta_data.sql
@@ -0,0 +1,13 @@
+SELECT * FROM (
+        SELECT c.relname AS label, n.oid as namespace_id, c.reltuples AS cnt
+        FROM pg_catalog.pg_class c
+        JOIN pg_catalog.pg_namespace n
+        ON n.oid = c.relnamespace
+        WHERE c.relkind = 'r'
+        AND n.nspname = '%s'
+) as q1
+JOIN ag_graph as g ON q1.namespace_id = g.namespace
+INNER JOIN ag_label as label
+
+ON label.name = q1.label
+AND label.graph = g.graphid;