Skip to content

[BUG]:drizzle-kit pull from Supabase db pgPolicy not importing rules correctly #4407

Open
@Anonymous2416

Description

@Anonymous2416

Report hasn't been filed before.

  • I have verified that the bug I'm about to report hasn't been filed before.

What version of drizzle-orm are you using?

0.41.0

What version of drizzle-kit are you using?

0.30.6

Other packages

No response

Describe the Bug

I have made policies in the Supabase ui dashboard. One policy insert withCheck (( SELECT auth.uid() AS uid) = id) then another policy for update with using (( SELECT auth.uid() AS uid) = id) and withCheck (( SELECT auth.uid() AS uid) = id). when I run drizzle-kit pull in the schema.ts file it only pulls the latest policy I updated. After making changes in supabase ui dashboard with those 2 policies I described above, here is the output below. it does not add the withCheck to my insert policy

pgPolicy("update_user", { as: "permissive", for: "update", to: ["public"], using: sql`(( SELECT auth.uid() AS uid) = id)`, withCheck: sql`(( SELECT auth.uid() AS uid) = id)`  }),
pgPolicy("insert", { as: "permissive", for: "insert", to: ["public"] }),

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions