cockroachdb / cockroachdb/cockroach-go
Feature Request: Support `BEGIN PRIORITY X` for pgx
- Dominant language
- Go
- Stars
- 169
- Forks
- 78
- PR merge metrics
- No merged PRs in 30d
Description
Currently there is no way to specify the priority of a transaction when using the pgx integration on initialization of the transaction. This results in another round trip to the DB with a `SET TRANSACTION PRIORITY`.
It would be stellar if there was an option in `crdbpgx.ExecuteTx()` that would allow specification of a transaction priority.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reading the crdbpgx.ExecuteTx() entry point and its transaction initialization path. Trace how transaction options are passed to the database and identify the existing tests around transaction setup; done means callers can specify transaction priority during initialization without the extra SET TRANSACTION PRIORITY round trip.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go
- Domain
- database
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100