req.payload should be bound to the request's transaction in hooks

[macrozone]

currently, if you want to do another db request in a collection, you may run into foreign key constraints or similar, because the record may not be created until the transaction finishes.

https://payloadcms.com/docs/database/transactions

you have to pass req, otherwise its not using the transaction:

 const conversation = await req.payload.create({
              collection: 'my-collection',
              data: data,
              req, // needs to be passed, alltough we are using req.payload
            })

this looks like an api design misstake and is a pitfall. Because you are using payload from req., you may expect it to be bound to the current request, while in reality, its not.

[matthijs166]

This explains a lot... yea I also expected that it would be automatically set