drizzle-team / drizzle-team/drizzle-orm

[FEATURE]: ability to skip policies

Open
#4,381 3 comments 2 reactions 0 assignees View on GitHub
db/postgres drizzle/kit enhancement
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

### Feature hasn't been suggested before.

- [x] I have verified this feature I'm about to request hasn't been suggested before.

### Describe the enhancement you want to request

Due to https://github.com/drizzle-team/drizzle-orm/issues/3504, I moved all the `pgPolicy` functions in the schema to a policies.sql file that I execute manually to craete all the policies.

But when I run `drizzle-kit push` it wants to drop all the policies. Is there a way I can let it skip the policies?

Contributor guide

Open the contributing guide

Research direction

Start with the drizzle-kit push flow and the pgPolicy definitions moved into policies.sql. Trace how push detects and plans policy drops, then check the schema and migration documentation for existing skip mechanisms. Done means users can run push without unwanted policy drops while retaining the manually managed policies.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, typescript
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.