Drizzle-kit push - pgPolicy ignores using configuration
Policy:
pgPolicy("Users can view their own active organization memberships", {
for: "select",
to: authenticatedRole,
using: and(
eq(table.userId, sql
eq(table.status, sql
),
})
Statement created with push:
CREATE POLICY "Organization members can view their associated organizations test" ON "organizations" AS PERMISSIVE FOR SELECT TO "authenticated";
The migration created doesnt have this issue.
pgPolicy("Users can view their own active organization memberships", {
for: "select",
to: authenticatedRole,
using: and(
eq(table.userId, sql
(select requesting_user_id())),eq(table.status, sql
'active'),),
})
Statement created with push:
CREATE POLICY "Organization members can view their associated organizations test" ON "organizations" AS PERMISSIVE FOR SELECT TO "authenticated";
The migration created doesnt have this issue.
