Merge branch '124-functions-exclusion' into 'master'

agneum · agneum · commit 748d30fa8729 · 2021-02-15T15:02:50.000Z
fix: exclude the change of ownership for dblink functions (joe#124) Closes #124 See merge request postgres-ai/database-lab!265
diff --git a/pkg/services/provision/databases/postgres/postgres_mgmt.go b/pkg/services/provision/databases/postgres/postgres_mgmt.go
@@ -160,6 +160,7 @@ begin
     from pg_catalog.pg_namespace as n
     join pg_catalog.pg_proc as p on p.pronamespace = n.oid
     where not n.nspname in ('pg_catalog', 'information_schema')
+    and p.proname not ilike 'dblink%%' -- We do not want dblink to be involved (exclusion)
   loop
     raise debug 'Changing ownership of function %%.%%(%%) to %%', 
                 r.nspname, r.proname, r.args, new_owner;
