(age-viewer) branch main updated: Fix Metadata Load Error in PG v13, v14 and v15 (#154)

[eya]

This is an automated email from the ASF dual-hosted git repository.

eya pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/age-viewer.git


The following commit(s) were added to refs/heads/main by this push:
     new 8a7f0be  Fix Metadata Load Error in PG v13, v14 and v15 (#154)
8a7f0be is described below

commit 8a7f0be2513e2aa4b2caf3d9833f4e2707f0001d
Author: Emmanuel Allison <emmanuelalli...@outlook.com>
AuthorDate: Fri Mar 22 01:12:08 2024 +0100

    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 | 13 +++++++++++++
 backend/sql/14/meta_data.sql | 13 +++++++++++++
 backend/sql/15/meta_data.sql | 13 +++++++++++++
 3 files changed, 39 insertions(+)

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;
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;
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;