fjuk
PPrisma
•Created by fjuk on 7/10/2024 in #help-and-questions
Date field default value
Thank you
5 replies
PPrisma
•Created by fjuk on 5/19/2024 in #help-and-questions
Unique index w/ nullable field in unique query
Forgot to mention I'm using a postgress db
7 replies
PPrisma
•Created by fjuk on 5/19/2024 in #help-and-questions
Unique index w/ nullable field in unique query
What about the nulls not distinct option?
7 replies
PPrisma
•Created by fjuk on 5/19/2024 in #help-and-questions
Unique index w/ nullable field in unique query
Trying to rewrite the generated sql migration to add the where clause to the unique index will just re-attemlt to generate the original index each time we run the migrations and unsyncs the db and the schema
The only way I managed to make it work was by removing the unique index entirely from the schema and create it via an empty migration, but then it won't be as obvious that it exists when looking at the schema, and the client won't provide the option to use the constraint in queries
7 replies
PPrisma
•Created by fjuk on 5/19/2024 in #help-and-questions
Unique index w/ nullable field in unique query
Is there any way to get the intended behavior?
7 replies
PPrisma
•Created by fjuk on 5/19/2024 in #help-and-questions
Unique index w/ nullable field in unique query
Oh right,
We were trying to cheat the behavior of
Unique Index ... where ...
Since I don't think it's supported either and we missed this
Thanks for the support 🙂
7 replies
PPrisma
•Created by fjuk on 3/17/2024 in #help-and-questions
how to create the _prisma_migration table in a specific schema?
Am I going to need to specify extra stuff for this to work with multiple schemas?
5 replies
PPrisma
•Created by fjuk on 3/17/2024 in #help-and-questions
how to create the _prisma_migration table in a specific schema?
In different schemas
5 replies