commit 68adc8b4af65efc4a660442230fd1e7a38cd90f0
author Orhan Kislal <okislal@apache.org> Thu Feb 23 12:25:16 2023 -0500
committer Orhan Kislal <okislal@vmware.com> Thu Feb 23 12:28:16 2023 -0500
tree a27c61e731c8191d9765181a002215833c8f2fcb
parent a7d182c872326133eda54b990094ad75d03e9d5e

SSSP: Drop temp views

src/ports/postgres/modules/graph/sssp.py_in

diff --git a/src/ports/postgres/modules/graph/sssp.py_in b/src/ports/postgres/modules/graph/sssp.py_in
index 09e4ce7..a1e640f 100644
--- a/src/ports/postgres/modules/graph/sssp.py_in
+++ b/src/ports/postgres/modules/graph/sssp.py_in
@@ -445,6 +445,7 @@
             plpy.execute("DROP TABLE IF EXISTS {0}".format(oldupdate))
             if vertex_in != 'id' and vertex_type == "BIGINT":
                 plpy.execute("ALTER TABLE {0} RENAME COLUMN id TO {1}".format(out_table, vertex_in))
+            plpy.execute("DROP VIEW IF EXISTS {vertex_view}, {edge_view}".format(**locals()))
     return None
 
 

src/ports/postgres/modules/graph/test/sssp.sql_in

diff --git a/src/ports/postgres/modules/graph/test/sssp.sql_in b/src/ports/postgres/modules/graph/test/sssp.sql_in
index 92aceb2..1fa0a1c 100644
--- a/src/ports/postgres/modules/graph/test/sssp.sql_in
+++ b/src/ports/postgres/modules/graph/test/sssp.sql_in
@@ -325,7 +325,7 @@
 SELECT * FROM out_summary;
 
 -- Test negative cycle
-DROP TABLE IF EXISTS vertex,"EDGE";
+DROP TABLE IF EXISTS vertex,"EDGE" CASCADE;
 
 CREATE TABLE vertex(
                   id INTEGER