Manual transaction handling in postgres

[cRYP70n-13]

Hello sorry for asking here maybe there has been some issue like this before but I tried looking online and in the documentation I see that there is only the automatic transaction handling, but in my case I want to actually have more control over it, commit and rollback manually instead of automatically, how can I do this please.

[goamaral]

I don't think it is possible.
The code that creates and handles the transaction is in the internal package.

Create transaction

db/internal/sqladapter/session.go

Line 308 in fb5164f

func (sess *sessionWithContext) NewTransaction(ctx context.Context, opts *sql.TxOptions) (Session, error) {

Handle transaction

db/internal/sqladapter/session.go

Line 1063 in fb5164f

func TxContext(ctx context.Context, sess db.Session, fn func(tx db.Session) error, opts *sql.TxOptions) error {

[cRYP70n-13]

Yeah I saw that, but what I wanted is to have a hand over the transaction and use it myself, because I have a very very special case that would require me to handle this manually instead of changing the whole implementation, IDK if that's possible with this or if there is any other way to put stuff inside of a single trx.