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.