Add debug output

hakuna · Mar 26, 2024 · 743a955 · 743a955
1 parent 7672270
commit 743a955
Showing 1 changed file with 2 additions and 9 deletions.
diff --git a/lib/tasks/rls.rake b/lib/tasks/rls.rake
@@ -34,16 +34,9 @@ namespace :rls do
 
   task create_role: :environment do
     RLS.without_rls do
+      puts "Current database: #{RLS.query_value("SELECT current_database()")}"
       RLS.connection.execute <<~SQL
-        DO $$
-        BEGIN
-          CREATE ROLE "#{RLS.role}" WITH NOLOGIN;
-        EXCEPTION
-          WHEN DUPLICATE_OBJECT THEN
-            RAISE NOTICE 'Role "#{RLS.role}" already exists';
-        END
-        $$;
-
+        CREATE ROLE "#{RLS.role}" WITH NOLOGIN;
         GRANT ALL ON ALL TABLES IN SCHEMA public TO "#{RLS.role}";
         GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO "#{RLS.role}";
         ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON TABLES TO "#{RLS.role}";