Does a nested write inside an interactive transaction collapse the transactions? #15213
-
|
If you have an interactive transaction that contains a nested write, will that cause an issue since nested writes are done with transactions? For example Does the nested write inside the transaction callback try to make another transaction nested inside of the interactive transaction? Or does the prisma client know to properly use the callback's transaction? Databases like postgres don't support nested transactions so it might cause silent failures if it doesn't work as expected. Initially mentioned here |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments 1 reply
-
|
Hey there 👋 thanks for raising this!
No.
Yes, Prisma Client will ensure that only one transactions is being opened, even if you include nested writes in an interactive transaction. |
Beta Was this translation helpful? Give feedback.
-
|
Awesome, thank you! |
Beta Was this translation helpful? Give feedback.
-
|
Hi there, To keep our discussions organized and focused on the most relevant topics, we’re reviewing and tidying up our backlog. As part of this process, we’re closing discussions that have already been marked as answered but remain open. If this discussion still requires further input or clarification, feel free to reopen it or start a new one with updated details. Your contributions are invaluable to the community, and we’re here to help! For more details about our priorities and vision for the future of Prisma ORM, check out our latest blog post: https://www.prisma.io/blog/prisma-orm-manifesto. Thank you for your understanding and ongoing support of the Prisma community! |
Beta Was this translation helpful? Give feedback.
Hey there 👋 thanks for raising this!
No.
Yes, Prisma Client will ensure that only one transactions is being opened, even if you include nested writes in an interactive transaction.