fix issue with permission denied for schema public

vbilopav · vbilopav · commit d779dbcd85bf · 2024-10-20T12:28:33.000+02:00
diff --git a/NpgsqlRest/RoutineSourceQuery.cs b/NpgsqlRest/RoutineSourceQuery.cs
@@ -6,7 +6,7 @@ internal class RoutineSourceQuery
     with _types as (
 
         select
-            (n.nspname::text || '.' || t.typname::text)::regtype::text as name,
+            case when n.nspname = 'public' then quote_ident(t.typname) else quote_ident(n.nspname) || '.' || quote_ident(t.typname) end as name,
             a.attnum as att_pos,
             quote_ident(a.attname) as att_name,
             pg_catalog.format_type(a.atttypid, a.atttypmod) as att_type
